Forum Discussion
JennyHoA20181
May 24, 2023Brass Contributor
Vlookup Match Index formula to look up 3 criteria
Hello, I hope someone can help. I am trying to create a Vlookup / Match formula to look up 3 criteria. My attempt below: =VLOOKUP($C2,'Weekly Extract'!$FF:$FX,MATCH(Forecasts!$D2,'Weekly Extr...
- May 24, 2023
In G2:
=IFERROR(INDEX('Weekly Extract'!$B$3:$S$19,MATCH(C2,'Weekly Extract'!$A$3:$A$19,0),MATCH(1,('Weekly Extract'!$B$1:$S$1=D2)*('Weekly Extract'!$B$2:$S$2='Weekly Extract'!$A$1),0)),"")
Fill down.
HansVogelaar
May 24, 2023MVP
Please explain what you want to match to what - the Weekly Extract sheet has data in completely different columns than those used in the formula.
And which column contains the data you want to return?
- JennyHoA20181May 24, 2023Brass ContributorHello - column H is selecting the values manually, in order to show what I want to match. Thanks
- HansVogelaarMay 24, 2023MVP
In G2:
=IFERROR(INDEX('Weekly Extract'!$B$3:$S$19,MATCH(C2,'Weekly Extract'!$A$3:$A$19,0),MATCH(1,('Weekly Extract'!$B$1:$S$1=D2)*('Weekly Extract'!$B$2:$S$2='Weekly Extract'!$A$1),0)),"")
Fill down.
- JennyHoA20181May 24, 2023Brass Contributor
HansVogelaar this works, thank you so much for your help!