INDIRECT SYNTAX within INDEX/MATCH

[Phillycheese5]

Hi,
I have a formula that works great.
=LEN(INDEX('7.31.20'!$A$9:$Z$40,MATCH($B5,'7.31.20'!$A$9:$A$40,0),MATCH($C5,'7.31.20'!$A$9:$Z$9,0)))

I am trying to aggregate data into one table that is on historical monthly sheets, 6.30.20, 5.31.20, etc. The 7.31.20 text is in cell BN4 but I am struggling on how to use it in the INDIRECT formula.

Any suggestions would be appreciated.

Thanks,

Phillycheese

[oeldere]

HOW TO ATTACH YOUR SAMPLE WORKBOOK:

Fast answers need clear examples. Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands...) and some manually calculated results. Just before posting, scroll down to GO ADVANCED, click, and then scroll down to MANAGE ATTACHMENTS and click again. Now follow the instructions at the top of that screen.

[Bo_Ry]

Please try at BM5

=LEN(VLOOKUP($B5,INDIRECT("'"&BM$4&"'!A9:Z40"),MATCH($C5,INDIRECT("'"&BM$4&"'!A9:Z9"),0),0))

[Phillycheese5]

Hi Bo,
Thank you for the help! The solution you provided works great!!
Phillycheese