Vlookup Match Index formula to look up 3 criteria

[JennySommet]

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!

[#2]

@JennySommet 

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?

[#3]

Hello - column H is selecting the values manually, in order to show what I want to match. Thanks

[#4 · Accepted solution]

@JennySommet 

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.

[#5]

@Hans Vogelaar this works, thank you so much for your help!