Forum Discussion
Solved
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...
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.
Hello - column H is selecting the values manually, in order to show what I want to match. Thanks
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 this works, thank you so much for your help!