I have a table of data, each colum is a name of a place (like LA, NY, etc...) and the data in each colum is a name of a person. I'm expecting not to place the same person in more than one location.
in a different place in the work-sheet I have a list of persons' names and I want to find what is their location.
So in general, I want to find in what colum a value is stored in a whole table, assuming it's shown only once.
"match" only works on an array, i.e. 1-dimentional table, which is not what I need.
Is there a way to do this? a formula I mean. Is there an add-in to Excel that has this formula?