Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Vlookup Mutiple Values
Is it possible to use vloolup to find every instance of a lookup value
and return the column index value for every instance and put that into 1 cell separated by a coma or something like that? A B C D 1 ZZ Z M O 2 JJ J A X 3 RR D W E 4 GG G E G 5 RR J I V 6 E,V Example in cell A6 =VLOOKUP(B4,B:E,4,0) I want it to return the value of E,V Is this possible |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Vlookup Mutiple Values
You have an active thread elsewhere.
Little Penny wrote: Is it possible to use vloolup to find every instance of a lookup value and return the column index value for every instance and put that into 1 cell separated by a coma or something like that? A B C D 1 ZZ Z M O 2 JJ J A X 3 RR D W E 4 GG G E G 5 RR J I V 6 E,V Example in cell A6 =VLOOKUP(B4,B:E,4,0) I want it to return the value of E,V Is this possible -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
if, and, Vlookup functions - mutiple matchng | Excel Worksheet Functions | |||
Vlookup on mutiple worksheets | Excel Discussion (Misc queries) | |||
vlookup for mutiple rows | Excel Worksheet Functions | |||
Vlookup Mutiple Values | Excel Discussion (Misc queries) | |||
how do i get mutiple values using vlookup in excel, lookup value . | Excel Discussion (Misc queries) |