Find a cell in skeleton data sheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
All depends on the data, but the =find function will probably do what you are
looking for.
 
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
 
Back
Top