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.

## Bookmarks