May 24 2023 07:17 AM
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 Extract'!$FF$1:$FX$1,MATCH('Weekly Extract'!$A$1,'Weekly Extract'!$FF$2:$FX$2,FALSE)))
Please see attached excel file where column G needs to use the Vlookup Match formula to show values in column F.
Thanks in advance for your help!
May 24 2023 07:44 AM
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?
May 24 2023 07:48 AM
May 24 2023 08:14 AM
SolutionIn 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.
May 24 2023 10:38 AM
@Hans Vogelaar this works, thank you so much for your help!
May 24 2023 08:14 AM
SolutionIn 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.