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
Put in L2
=IFERROR(INDEX($B$1:$F$1,MOD(SMALL(IF($B$2:$F$9=$K2,(ROW($B$2:$F$9)-ROW($B$2)+1)*10^5+COLUMN($B$2:$F$9)-COLUMN($B$2)+1),COUNTIF($K$2:K2,K2)),10^5)),"")
and press all together CTRL+SHIFT+ENTER button (array formula style), and then copied down
I don't know how you did it but this is perfect. Thanks you so much.
This is shorter
=INDEX(B$1:F$1,MAX(IF($B$2:$F$9=K2,COLUMN(B$1:F$1)-COLUMN(B$1)+1)))
Array formula, use Ctrl-Shift-Enter
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks