Forum Discussion
vinedancer
Sep 30, 2022Copper Contributor
Excel - 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 ...
Patrick2788
Sep 30, 2022Silver Contributor
This is a classic VLOOKUP-MATCH/INDEX-MATCH setup. Please see attached: