is there a way i can list all entries that the vlookup looks up? example:
source:
1=r
2=b
2=c
3=u
3=e
if i do a vlookup to look up "2" it will have "b" and "c" but only "b" will show up since it's the first one. i need to be able to have it as "b ; c" as the output..
Bookmarks