Hello there,
I need a formula to find a match for a cell, and then return the title of the column in which the match was found.
Screen Shot 2021-05-03 at 6.20.54 PM.png
If value of H3 is found in any cell between V3 to AA22, then return value of that corresponding column, in I3.
So for e.g. in cell I3, I want the formula to return back "Bundesliga - Germany".
Thank you for all the help!
Bookmarks