| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Searching Lists
I have a list of names in Column A e.g.
A B NAFTA OPEC CCNA WIF and want to query that list and have the result display in cell B6 e.g. NAFTA. I don't know which cell the information is in but wish to search A1:A4. which one of the functions should I be using. I know I can do =A1 from cell B6 but I want to search the range automatically. Thanks in advance for your help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Searching, matching then searching another list based on the match | Excel Discussion (Misc queries) | |||
| LISTS- adding info without repeat to other lists | Excel Discussion (Misc queries) | |||
| Multiple lists with repeated values for dependet drop down lists | Excel Worksheet Functions | |||
| Searching Two Not-That-Similar Lists | Excel Discussion (Misc queries) | |||
| Alpha searching in lists. | Excel Discussion (Misc queries) | |||
Threaded Mode
