I have a sheet with a table in it. The table is in cells B1:F9. I also have a list of names in cells K2:K9. What I'd like to do is in cells L2:L9 is have a formula that would look up the names in column K in the table and if it finds it then return the column Header it found it in. I've attached a sample workbook.
Hopefully I uploaded the file correct.
Thanks in advance
Excel 2010
Bookmarks