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