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.
