| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
matching from an unsorted list
I'd like to match (exact) names from a range of text, but the range is
unsorted. Is there a function or method to do this? i.e. I enter a name in a cell, and a formula would take that cell and match against a range of names. thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
matching from an unsorted list
Most people would use the Vlookup function. Read up on it in Help. Pay
special attention to the last parameter. Post back if you need help. Regards, Fred "d fallon" <d wrote in message ... I'd like to match (exact) names from a range of text, but the range is unsorted. Is there a function or method to do this? i.e. I enter a name in a cell, and a formula would take that cell and match against a range of names. thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup unsorted list | Excel Discussion (Misc queries) | |||
| How do I find top 3 in an unsorted list? | Excel Worksheet Functions | |||
| lookup unsorted list | Excel Discussion (Misc queries) | |||
| An unsorted list in vlookup | Excel Worksheet Functions | |||
| Matching unsorted lookup values | Excel Worksheet Functions | |||
Linear Mode
