I'm having issue to understand if it's possible to reverse and Index match formula to get the column name given a match in a table's coordinate. Let me write an example to make it clear:

assume I have the table above/image: I'd like to get the sport each person chose based on the x coordinates in the table.

Is there a way to do this?

Thanks a lot

Best regards Luca

CodePudding user response：

Right, now that you made your example a bit clearer, try:

Formula in I2:

=INDEX(B$1:F$1,MATCH("x",INDEX(B$2:F$6,MATCH(H2,A$2:A$6,0),0),0))