Find Table Heading

**mikehoncho** · 12-12-2011, 06:23 PM

I'm trying to search for a way to lookup the top row based on the intercept of the row and column and have been racking my brains all afternoon. I have a matrix where owners are assigned based on an ID number and I'd like to return the owner. For example 1.4 below should return Owner 2. I've tried various combos of index/match and lookup and array formulas but to no avail.

Thanks in advance for your help.

ID, Owner 1, Owner 2, Owner 3
1.2 , ,X ,
1.3 ,X ,
1.4 , ,X ,
1.5 , , ,X

**TMS** · 12-12-2011, 06:32 PM

=INDEX($A$1:$D$1,MATCH("x",$A2:$D2,0))

Regards, TMS

**mikehoncho** · 12-12-2011, 10:37 PM

TMS, thanks for your quick reply. I'm trying to use the ID (1.2,1.3, ...) as a variable to search on as well for a list of ID's. I think the above only returns the "owner" for a known row. I can match the row, ie 1.4 in row 3 but am trying to again match the "X" in that row to get the column header as the owner.

I think I could always create another sheet and just do the lookup so I get two columns, one with ID and the other with owner and then hide and index off of that to get the owner for a given ID. I'd like to avoid it though if possible for cleanliness.

Thanks again for any help.

**TMS** · 12-13-2011, 04:10 AM

I don't really understand your description of the problem.

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.