Index and match with multiple criteria

Question

Hi&nbsp;Can someone please help me with an Index and Match formula.I am trying to find a way to pull back the data using multiple criteria, but not sure if it is possible with INDEX and MATCH or if I need to try something different.In the attached file you will see that I have tried a couple of different formulas. I am trying to look up the Month in column I and return the value from Column K-P where the value in Row1 and value in Row2 match. Is this possible?

detlef_lewin · Answer

Carlyn1505&nbsp;=INDEX($K$4:$P$15,MATCH(A4,$I$4:$I$15,0),MATCH($B$1&amp;$B$2,$K$1:$P$1&amp;$K$2:$P$2,0))

carlyn1505 · Answer

Thank you so much for your help!

Forum Discussion

Index and match with multiple criteria

Share

Resources