Indirect match index formula question involving different spreadsheet name

Hello!

I was assisted in a previous post with the use of this formula:

Please Login or Register  to view this content.

This particular formula is placed in cell AZ4. I have a month in cell AY4 (that would say January). Is there a way that I could edit this array formula so that the "January!" in red above wouldn't need to specify a given month but would instead change to reflect the month specified in cell AY1.

I tried this this but it didn't work:

Please Login or Register  to view this content.

Any assistance would be greatly appreciated!

Maybe this...

The INDIRECT function inside the MATCH function should be:

MATCH(Payroll!$AY5,INDIRECT($AY$1&"!A5:A49"),0)

You're welcome. Thanks for the feedback!