| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Want Vlookup to list multiple items with the same key?
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| why won't vlookup work in a long list | Excel Worksheet Functions | |||
| how do I use vlookup for multiple occurrences of the same value | Excel Worksheet Functions | |||
| Items in a List | Excel Discussion (Misc queries) | |||
| Transfer Items to a list with no duplicates | Excel Worksheet Functions | |||
| Can VLOOKUP return multiple answers based on several identical lo. | Excel Worksheet Functions | |||
Threaded Mode
