Find a cell in skeleton data sheet

E

Elango

I have flight ticket data in both rows & columns in a sheet.
I need to find a data refering a particular text i.e Name, Destination
what is the formula to pick up the particular data
 
J

John Bundy

All depends on the data, but the =find function will probably do what you are
looking for.
 
V

vezerid

I suspect it is a construct of the form

=VLOOKUP(name, area, MATCH(dest, headers,0), 0)

But without any more information I cannot suggest anything concrete.

HTH
Kostis Vezerides
 
Top