I am looking for a value in a table array then need to return the column header of the column in which it is found. See attached simple spreadsheet. In Cell B2, the value in cell E1 should be returned. Slight complication is that it shouldn't be an exact match - if it only contains the lookup value, it should still return it. Lookup example.xlsx
Bookmarks