Forum Discussion
Using IF and VLOOKUP together
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 ...
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)
OMG you're a genius! Thank you, it worked 🙂