View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Little Penny Little Penny is offline
external usenet poster
 
Posts: 64
Default 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