Sep 29 2022 09:35 PM
I have a workbook where the first sheet has dates in the heading and the data for those columns is on another sheet. I want to combine an If statement to pick up the date, then lookup the items (say Food purchases) and return either column 2, 3 or 4 depending on the date heading.
Not sure of the exact syntax but tried all sorts to get the IF and VLOOKUP to work together.
=IF($J$5='P&L25.9 '!$C$4,"vlookup,'2023'!A6,'P&L25.9 '!$a$6:$Z$60,4",0)
This statement isn't working.
Thanks :)
Sep 29 2022 09:42 PM - edited Sep 29 2022 09:43 PM
@vinedancer This syntax should work, though I can't test it if returns the desired result.
=IF($J$5='P&L25.9 '!$C$4,VLOOKUP('2023'!A6,'P&L25.9 '!$A$6:$Z$60,4,0),"-")
It performs the VLOOKUP when the criteria is met or "-" if it is not)
Sep 29 2022 09:49 PM