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



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



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

1 Reply


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: