Vlookup/Match error

[ExcelAtEverything]

Hello,

In screenshot #1 below, I'm using a VLOOKUP/MATCH combination to try and pull the plan numbers from whichever month is in cell F8 of screenshot #2. The following formula which I'm using does not work, however. I'd like to perform this action without using VB if possible. Could someone tell me either what I'm doing incorrectly, and/or how to fix it.
=VLOOKUP([@[Loc '#]],Annual_Plan_Numbers_Reports__2,MATCH('Calc Data'!F7,Annual_Plan_Numbers_Reports__2[[#Headers],[Jan]:[Dec]]),FALSE)


Note: It seems to only be the MATCH portion that isn't working, because when I replace the entire MATCH formula with just a column count like this, of course it works perfectly.
=VLOOKUP([@[Loc '#]],Annual_Plan_Numbers_Reports__2,7,FALSE)

Thx so much for assistance!

In screenshot #1, Row #1 contians a date format.

In screenshot #2, F8 contains the formula =Today() (with a custom format).

 

[Anthony47]

I din't understand the details of your formula, for example what Annual_Plan_Numbers_Reports__2 corresponds to; but would suggest you use INDEX/Match/MonthOfF8; in some detail:

INDEX(TheTable,MATCH(What-is-necessary-to-point-the-right-Row,MONTH(F8)+4)

The "+4" assumes that TheTable is the one shown in pict #1, where Jan (Month #1) is column #5

Bye

 

[ExcelAtEverything]

Hey, thanks Anthony47. Sorry yes, I forgot to mention that! Annual_Plan_Numbers-Reports__2 refers to screenshot #1, and Calc Data refers to screenshot #2.
I tried using Index Match, but the same was happening where it seemed like it shoud be working. I'll try it again, using Month like you suggested since I did that part differently.