Excel - LOOKUP Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

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.
Solved by C. L. in 18 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 18/08/2017 - 11:19
Hello :) How can I help you today?
User 18/08/2017 - 11:21
M question is as above regarding inserting an indirect function into the above formula
Excelchat Expert 18/08/2017 - 11:22
I see that.
Excelchat Expert 18/08/2017 - 11:22
Thank you.
Excelchat Expert 18/08/2017 - 11:22
Now we can continue into the explanation step of this session. I am going to perform the following:
Excelchat Expert 18/08/2017 - 11:23
You would replace pump with indirect(concatenate(Cell named the tab,"!A4:A22))
Excelchat Expert 18/08/2017 - 11:26
See how B1 references Sheet2 through indirect?
User 18/08/2017 - 11:28
i can't see a spreadsheet
Excelchat Expert 18/08/2017 - 11:28
Do you have the file available?
User 18/08/2017 - 11:28
yes how do i upload it?
Excelchat Expert 18/08/2017 - 11:28
https://docs.google.com/spreadsheets/d/1Dv3AXMsqjckA7YIKeV71LpHrSyVuc0JSrsrDX_hGfFk/edit?usp=sharing
Excelchat Expert 18/08/2017 - 11:28
Please click this link?
Excelchat Expert 18/08/2017 - 11:32
You can upload the file by clicking the paperclip to the right of the chat box. It's blue box with white paperclip.
Excelchat Expert 18/08/2017 - 11:34
Please note, the session will end in 4 minutes.
User 18/08/2017 - 11:35
I'm trying to upload it but am just getting a red circle with a white 1 in it

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.