Thanks. That was the problem.
I never would have figured that out.

"Biff" wrote:

Hi!

You probably didn't enter the formula as an array.

Type the formula then hold down the CTRL key and the SHIFT key then hit
ENTER.

Biff

"lo3t3ch" wrote in message
...
It appears to be getting the correct number of responses, but I'm only
getting "#VALUE!" for responses.

"Biff" wrote:

Hi!

One way:

C1 = lookup value

Entered as an array using the key combo of CTRL,SHIFT,ENTER:

=IF(ROWS($1:1)<=COUNTIF(A$1:A$5,C$1),INDEX(B$1:B$5 ,SMALL(IF(A$1:A$5=C$1,ROW(A$1:A$5)-ROW(A$1)+1),ROWS($1:1))),"")

Copy down until you get blanks.

Biff

"lo3t3ch" wrote in message
...
How can I have a lookup (or other function) find all values in column A
that
match my lookup value? Simplified Example:
A B
1 cat
1 dog
2 bird
3 hamster
3 fish

I would like to look up "1" and have it return both "cat" and "dog",
not
just "cat".
Is this possible?