How to insert INDIRECT within INDEX & MATCH functions

Hi,
I need to find a dynamically changing sheet name and then use in in an INDEX + MATCH function combination. I managed to find the sheet name by use of the following formula =INDIRECT("Plan'"&"!B13") for a cell B13 in sheet "Plan" that contains it, but cannot determine the proper syntax to insert this expression into the following one =INDEX('sheet name'!E22:E41,MATCH(A13,'sheet name'!B22:B41,0)) where 'sheet name' is the result of the previous INDIRECT function. Any ideas will be greatly appreciated.

Originally Posted by 6StringJazzer

Do you need this formula to be able to be copied to multiple locations, or is it one formula in one cell? This version is not copyable, because the cell ranges are in quotes:

Formula:

Please Login or Register  to view this content.

Thank you, but doesn't seem to work. Can't find how to attach my sample file, maybe permission is needed.

Originally Posted by 6StringJazzer

No special permission is needed, but the paper clip icon does not work. To attach a file, under the text box where you type your reply click the Go Advanced button. On the next screen scroll down and click on Manage Attachments, which will show a pop-up window to Select and Upload a file. Then close the window.

Thanks, attached is the sample file

Originally Posted by JeteMc

Try pasting the following into cell H13: =INDEX(INDIRECT("'"&B13&"'!E22:E41"),MATCH(A13,INDIRECT("'"&B13&"'!B22:B41"),0))
Let us know if you have any questions.

Solved my issue! Thanks