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

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?

No

Biff

"Little Penny" wrote in message
...
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

Not with VLOOKUP, but you can try an IF/INDEX formula:
I assume that "ZZ" is located at B2.
Then select B2:E6 and
Insert Name Define Names in workbook: Array
Next, define the name Out:
Insert Name Define Names in workbook: Out
Refers To: =IF(INDEX(Array,,1)=$B$6,INDEX(Array,,4)&",","")
In cell A6, enter this formula:
=INDEX(Out,1)&INDEX(Out,2)&INDEX(Out,3)&INDEX(Out, 4)&INDEX(Out,5)