Forum Discussion
Solved
index match not working
=INDEX(state!$B$1:$F$1,MATCH(contra!A2,state!$A$2:$A$10,0),MATCH(contra!B2,state!B2:F2,0)) I have 2 data sets state and contra and I am trying to retrieve heading from state. but this is not work...
Use
=IFERROR(INDEX(State!$B$1:$F$1, MATCH(B2, INDEX(State!$B$2:$F$10, MATCH(A2, State!$A$2:$A$10, 0), 0), 0)), "-")
Use
=IFERROR(INDEX(State!$B$1:$F$1, MATCH(B2, INDEX(State!$B$2:$F$10, MATCH(A2, State!$A$2:$A$10, 0), 0), 0)), "-")