Lookup Value in Range/Array and Return Column Header Value
I'm trying to make table tents for a banquet and need a formula that
will return the table number for the specific guest.
Excel Layout:
Table #: 1 2 3
Joe Mary Adam
Mike Erin Steve
Ann Ken Jill
Lookup Erin Returns table 2
Lookup Adam Returns table 3
Lookup Ann Returns table 1
etc.
I've tried v and h lookups but those can't use a range/array of values
(the names of the guests). I'd prefer a function but willing to use VBA
if need be. I'm guessing I need a match or similiar function but can't
seem to figure it out.
Any help would be great.
|