I tried it with the same data, location and formula that you posted. dint
change anything.

"Biff" wrote in message
...
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