Forum Discussion

JennyHoA20181's avatar
JennyHoA20181
Brass Contributor
May 24, 2023
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...
  • HansVogelaar's avatar
    HansVogelaar
    May 24, 2023

    JennyHoA20181 

    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.

Resources