Are you stuck on Excel or Google Sheets?

I would like to use some sort of lookup to generate data based on a dropdown list value.

I have the following formula =IF(G5>20,0,LOOKUP(G5,'0-1 pump'!A4:A22,'0-1 pump'!L4:L22)) I would like to replace '0-1 pump'!A4:A22 and 0-1 pump'!L4:L22 to automatically link with an indirect function to these columns but in different worksheets depending on a list of worksheet names in a cell.

How can I use lookup in excel for analysis the data

Need help with lookup when you have multiple lookup values

V lookup formula to populate fields based on a criteria

I have a complex lookup formula but don't know why it isn't working now.

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.

need help with lookup when i have multiple lookup values. Plz help me

How do I lookup and return an answer to a formula when I want it to do a partial match? Say one spreadsheet has spf1234 and I want it to pull in an answer matching just "1234".

I need a formula to do a lookup from one text list and deliver a text result