Index and Match Function

Copper Contributor

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!!!

1 Reply

@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:

Patrick2788_0-1720541490298.png