Forum Discussion
Solved
Query related to show numbers according to its data
Hello Everyone, I want to show NUMBER for A and S to a main data. I tried the INDEX with MATCH function. But it did not work. Please help.. Here is a attached file..
Please try this...
In H2
=IFERROR(INDEX($C$2:$C$9,MATCH(1,INDEX(($A$2:$A$9=$G2)*($B$2:$B$9=H$1),),0)),"")and then copy it across and down.
Excel Try with SUMIFS or why not just a simple pivot table?