Need Help with Indirect/Match formula

[odonovanc]

I have a workbook with many tabs. One set of tabs are years, 2020, 2021, etc. Then I also have tabs for each month of the years so Mar 2021, Apr 2021, etc.

I am trying to create a lookup where a formula will look up the correct month tab, in this case Mar 2021. Here is my formula and where I am:

=-IFERROR((IFERROR(VLOOKUP($C64,INDIRECT(M$62&"!$C$5:$T$50000"),MATCH(M$61,INDIRECT(M$62&"!$C$4:$T$4"),0),0),0)),"")

Some details: in my current sheet, M61 is the month "Mar" and M62 is the Year "2021". I need my formula to lookup C64 from my current sheet to the Mar 2021 tab and match the month found in cell M61 to row 4 of the Mar 2021 tab.

My formula is pulling in the amounts from just the "2021" tab and not the Mar 2021 tab like I am trying to do. Everything is pulling correctly, it is just pulling from the wrong sheet. How can I tweak this to get it to pull from Mar 2021 tab instead of just 2021?

 

[KRice]

This part of your formula is telling VLOOKUP to look only at the 2021 sheet.

INDIRECT(M$62&"!$C$5:$T$50000")

If you want this to refer to the Month-Year tab, then:

INDIRECT("'"&M$61&" "&M$62&"'!$C$5:$T$50000")

Note the character nested between those double quotes is a single quote " ' " without the spaces...and the 2nd occurrence is " ' ! again without spaces.
That forms the string 'Mar 2021'!$C$5:$T$50000. Your other INDIRECT formula may need attention too.

 

[odonovanc]

This part of your formula is telling VLOOKUP to look only at the 2021 sheet.

INDIRECT(M$62&"!$C$5:$T$50000")

If you want this to refer to the Month-Year tab, then:

INDIRECT("'"&M$61&" "&M$62&"'!$C$5:$T$50000")

Note the character nested between those double quotes is a single quote " ' " without the spaces...and the 2nd occurrence is " ' ! again without spaces.
That forms the string 'Mar 2021'!$C$5:$T$50000. Your other INDIRECT formula may need attention too.

This is perfect. Thanks so much.

 

[KRice]

Great!...glad to help.