| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
vlookup and concatenate multiple occurences
Hello all,
I am trying to do a vlookup with multiple occurences of the same value, then return the next column over concatenated with all of the other occurences. For instance. If I had A1 = 1 A2 =1 and A3 = 2. If B1 = Dog, B2 = cat, and B3 = gopher. If I were looking up 1 in column A there are 2 occurences so i woudl want it to return Dog, Cat. Can this be done, or do I need a for next loop? Jay |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup & Concatenate? | Excel Discussion (Misc queries) | |||
| Need to Count Occurences in Multiple Ranges | Excel Worksheet Functions | |||
| How to map multiple occurences of xml element in a sequence to Exc | Excel Discussion (Misc queries) | |||
| Concatenate and Vlookup | Excel Worksheet Functions | |||
| Can you use Concatenate with the If function with vlookup in the i | Excel Worksheet Functions | |||
Linear Mode
