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?
JennyHoA20181
May 24, 2023Brass Contributor
Hello - column H is selecting the values manually, in order to show what I want to match. Thanks