INDEX(MATCH()) - Index a specific worksheet based on cell value

[VegaOne16]

Hello,

Say I have two worksheets in a workbook.

One sheet called TIE OUT, and the other DTSE.

I have the following formula in cell L4:

=IFERROR(INDEX(DTSE!$A$1:$Q$307,MATCH((EOMONTH(D4,-2)+1),DTSE!$A$1:$A$307,0),L$1),"")

What I'm trying to accomplish is have DTSE! be referenced to a cell (say M4) in TIE OUT, verses hard coded. I have 250 worksheets with different names, and changing each manually would take a lot of time, so I'm trying to save time

Thank you for your knowledge sharing.

 

[Fluff]

You need the INDIRECT function try

=IFERROR(INDEX(INDIRECT("'"&M4&"'!$A$1:$Q$307"),MATCH((EOMONTH(D4,-2)+1),INDIRECT("'"&M4&"'!$A$1:$A$307"),0),L$1),"")

 

[VegaOne16]

This is magic, I'll have to learn about the INDIRECT function, thank you very much!!!!!!!

 

[Fluff]

Glad to help & thanks for the feedback