ExcelAtEverything
Active Member
- Joined
- Jan 30, 2021
- Messages
- 351
- Office Version
- 2019
- Platform
- Windows
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).
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).