Vlookup Mutiple Values

[Little Penny]

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]

You have an active thread elsewhere.

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