Forum Discussion

Excel's avatar
Excel
Iron Contributor
Jul 16, 2022
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..

excel
Formulas and Functions
  • Subodh_Tiwari_sktneer's avatar
    Subodh_Tiwari_sktneer
    Jul 16, 2022

    Excel 

     

    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.

4 Replies

Resources