Forum Discussion
Index Match Multiple Criteria
I am a newbie and I understand the general index match lookups. However I am struggling with a more complicated set of information that needs an index match but with applicability criteria. Examp...
In L4:
=INDEX($A$5:$A$150,SUM(($B$5:$B$150=M4)*($C$4:$J$4=N4)*($C$5:$J$150>0)*(ROW($A$5:$A$150)-ROW($A$5)+1)))
Adjust the ranges if needed, then fill down.
- Many thanks - it works very well
