something more than vlookup??
Tell me the EXACT location of you're data and post the EXACT formula you
used.
Biff
"Gary" wrote in message
...
Also, if i enter G or B in D2, it still gives me E456.
"Biff" wrote in message
...
Hi!
This data is in the range A2:B6:
E456 --- A
E123 --- B
E222 --- A
F567 --- G
D333 --- A
D2 = lookup value = A
Enter this formula as an array using the key combination of
CTRL,SHIFT,ENTER:
=IF(ROWS($1:1)<=COUNTIF(B$2:B$6,D$2),INDEX(A$2:A$6 ,SMALL(IF(B$2:B$6=D$2,ROW(A$2:A$6)-ROW(A$2)+1),ROWS($1:1))),"")
Copy down until you get blanks.
Biff
"Gary" wrote in message
...
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
|