Indirect Formula

[shull82]

Hi everyone question about referencing a tab name for indirect index match.

H2 on this tab is "January"
I have tabs labeled for each month.
The following formula is working, but I'm trying to indirect reference in the match part of the formula the way I did with Index.

=IFERROR(INDEX(INDIRECT("'"&H$2&"'!$A$1:$AQ$5000"),MATCH($C4,January!$A$1:$A$5000,0)+15,28),"")

I'm using formula below but it is not returning a value.
=IFERROR(INDEX(INDIRECT("'"&H$2&"'!$A$1:$AQ$5000"),MATCH($C4,INDIRECT("'"&H$2&"'!$A$1:$AQ$5000",0))+15,28),"")

Thank you in advance for any help!

 

[Fluff]

The 2nd Indirect should just be looking at col A, not columns A to AQ

 

[shull82]

Amazing! Thank you soooo much

 

[Fluff]

You're welcome & thanks for the feedback.