| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find Same Cell... Different Sheet??? | Excel Discussion (Misc queries) | |||
| How to use VLOOKUP to find data on another sheet | Excel Worksheet Functions | |||
| Find data from one sheet in another sheet | Excel Worksheet Functions | |||
| Find MAX data in sheet (Cell) - Any cell that exceeds X amount of data | Excel Discussion (Misc queries) | |||
| find data from other sheet | Excel Worksheet Functions | |||
Linear Mode
