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)), "-")
For Airlines7 and Airlines8 there are 2 matches. To return both of them:
=FILTER(State!$B$1:$F$1, FILTER(State!$B$2:$F$10, State!$A$2:$A$10=A8, "")=B8, "")
or to return the result in one cell:
=TEXTJOIN(", ", TRUE, FILTER(State!$B$1:$F$1, FILTER(State!$B$2:$F$10, State!$A$2:$A$10=A2, "")=B2, ""))
- this is too good.
