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