Forum Discussion
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 n...
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: