Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
something more than vlookup??
Hi,
I have a database of Requestors and Request IDs. I used Vlookup to Return the requestors name if i enter a request ID coz one request ID can be of one requestor only. But....One requestor can have many request IDs. Now what function should I use to return all the request IDs if I enter one requestor's name. For example --- E456 --- A E123 --- B E222 --- A F567 --- G D333 --- A Now as per this sample, If i enter E456, VLOOKUP would return A. But If I enter A, I want excel to return E456, E222 and D333. Thanks in advance. GARY |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLookup a Vlookup | Excel Worksheet Functions | |||
VLOOKUP Problem | Excel Discussion (Misc queries) | |||
VLOOKUP Limitations | Excel Worksheet Functions | |||
vlookup data hidden within worksheet | Excel Worksheet Functions | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |