Re: Want Vlookup to list multiple items with the same key?

Take a look at this sample file:

http://s19.yousendit.com/d.aspx?id=11C7VN3PMW9J03CJM84T9Z306Y

Biff

"GarToms" <GarToms.21skqp@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:GarToms.21skqp@xxxxxxxxxxxxxxxxxxxxxxx
>
> I have found this formula that does a similar function to what I require
> however I am unable to edit it to A1:C1000. Does anyone know how to
> amend this to work?
>
> =INDEX(Sheet1!B$2:B$4,SMALL(IF(Sheet1!$A$2:$A$4=$A
> $1,ROW($1:$3)),ROW(1:1)))
>
>
> GarToms Wrote:
>> I want to do a function similar to a vlookup. I want to input a key
>> into a cell and have the relevant names listed. The problem I have is
>> the vlookup only shows one of the multiple names. Is there a way to
>> list all of the names?
>>
>> Input Key: ____
>>
>> Key Name
>> 1414 BRODRENE DAHL A/S
>> 1880 MAN FERROSTAAL AG
>> 2356 HEITON BUCKLEY LIMITED
>> 2356 HEITON BUCKLEY LIMITED1
>> 2356 HEITON BUCKLEY LIMITED2
>> 2356 HEITON BUCKLEY LIMITED3
>> 3867 STAVANGER RORHANDEL A/S
>> 4367 CLEANAWAY LTD
>> 4618 ALUKONIGSTAHL GMBH
>> 4618 ALUKONIGSTAHL GMBH1
>> 4979 MARMON/KEYSTONE ANBUMA N.V.
>>
>>
>> Ideal Output
>>
>> Input Key 2356
>>
>> HEITON BUCKLEY LIMITED //all brought up by a formula
>> HEITON BUCKLEY LIMITED1
>> HEITON BUCKLEY LIMITED2
>> HEITON BUCKLEY LIMITED3
>>
>> I would appreciate any assistance.
>> Thanks.
>
>
> --
> GarToms


.