Find a cell in skeleton data sheet
 

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

Find a cell in skeleton data sheet
 

All depends on the data, but the =find function will probably do what you are
looking for.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Elango" wrote:

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

Find a cell in skeleton data sheet
 

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

On Oct 18, 5:05 am, Elango wrote:
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