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
|