Hello,
Is is possible to do a vlookup in a cell with comma separated values and return it in another comma separated value (in red)
example :
I want top obtain Col B result vlooking up in second table. Your help is the most welcome.
Thanks
Jacques.
Vlookup table :
Is is possible to do a vlookup in a cell with comma separated values and return it in another comma separated value (in red)
example :
I want top obtain Col B result vlooking up in second table. Your help is the most welcome.
Thanks
Jacques.
A | B | |
---|---|---|
1 | GERMANY,SPAIN,FRANCE | DE,SP,FR |
2 | FRANCE,ARGENTINA | FR,AR |
3 | DENMARK | DK |
Vlookup table :
ARGENTINA | AR |
GERMANY | DE |
FRANCE | FR |
SPAIN | SP |
DENMARK | DK |