Forum Discussion

dmireles's avatar
dmireles
Copper Contributor
Jul 09, 2024

Index and Match Function

Hello all,

 

I'm taking a intro to underwriting course and I'm stuck on the Index and Match function 

 

This is the same exact formula that shown in the course but for some reason my excel does not accept it

=INDEX(F3:M8,MATCH(A7,E3:E8,0)MATCH(B7,F2:M2,0))

 

Excel Suggests a new formula with the * before the second MATCH as shown bellow

=INDEX(F3:M8,MATCH(A7,E3:E8,0)*MATCH(B7,F2:M2,0))

 

Does anyone have any feedback or can point me in the right direction? Thank you!!!

Excel on Mac
Formulas and Functions
training
  • Patrick2788's avatar
    Patrick2788
    Silver Contributor
    Jul 09, 2024

    dmireles 

    You're missing a comma before the second match.  Also, Excel is not always correct when offering to fix the syntax error for you.

     

    Formula should be:

     

    =INDEX(F3:M8, MATCH(A7, E3:E8, 0), MATCH(B7, F2:M2, 0))

     

     

    As an aside, this is a good reason to enable Excel labs to use Advanced Formula Environment.  Pasting in the original formula makes the syntax error apparent:

     

     

Resources