Excel - using If and Vlookup together

Copper Contributor

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.


No sure of the exact syntax and 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 :)

2 Replies


Hello! You've posted your question in the Tech Community Discussion space, which is intended for discussion around the Tech Community website itself, not product questions. I'm moving your question to the Excel space - please post Excel questions here in the future. 


This is a classic VLOOKUP-MATCH/INDEX-MATCH setup. Please see attached: