Re: Returning multiple instances of the same lookup value
- From: "Biff" <biffinpitt@xxxxxxxxxxx>
- Date: Wed, 30 Nov 2005 18:21:51 -0500
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" <lo3t3ch@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:A2EB6B4F-01D4-46D6-A739-638B738B8EA9@xxxxxxxxxxxxxxxx
> 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" <lo3t3ch@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:F895986E-CDB6-4DD1-A4E0-AC6E608AC924@xxxxxxxxxxxxxxxx
>> > 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?
>>
>>
>>
.
- References:
- Prev by Date: Re: Pop-Up Message
- Next by Date: Re: Longest string in a column
- Previous by thread: Re: Returning multiple instances of the same lookup value
- Next by thread: Re: Returning multiple instances of the same lookup value
- Index(es):
Relevant Pages
|
