Forum Discussion
Carlyn1505
Jul 03, 2024Copper Contributor
Index and match with multiple criteria
Hi 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 ...
Detlef_Lewin
Jul 03, 2024Silver Contributor
=INDEX($K$4:$P$15,MATCH(A4,$I$4:$I$15,0),MATCH($B$1&$B$2,$K$1:$P$1&$K$2:$P$2,0))
Carlyn1505
Jul 03, 2024Copper Contributor
Thank you so much for your help!