Are you stuck on Excel or Google Sheets?

i want to lookup a alphanumeric value(eg. EMP789 ) from a coloumn range i use =VLOOKUP(REPT("z",255),C:C,1) to get text value

I need to analyse data and not always return the 1st instance of a lookup. Eg. I have an account number, ID number and a domain name There are instances where the same account and ID numbers on a row have a different domain name. My use so far always defaults to give me the 1st instance of that combination, but I need to return all domain names, either in one cell or separate cells Is this possible ?

Need help with lookup when you have multiple lookup values

I'm looking to create a formula that based on a master order list will take data and bring into another sheet, like the customers name, and other fields. So what I have is an Invoice Number (ie. 18-001) and I want to enter that 18-001 onto a billing sheet and have many data boxes lookup who the customer was, what was performed and what rate applies. All of this is populated into the master order list, how can I make it automatically update from that list onto another sheet?

Use the HLOOKUP function in cell H11 to calculate freight cost based on the shipping class and state to which the shipment is going. Freight Cost can be referenced on the "Freight Cost" lookup table (range E5:N8). Be sure to use appropriate relative and absolute cell references. Hint: You will need to use a function within the HLOOKUP function to determine the appropriate row.

Hello. I need to assign 5 categories a number and was hoping to use a lookup function to make it easier for me (would like A-E to be associated with #1-5)