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