VLOOKUP from a cell with multiple search values separated by commas and return multiple values separated by commas

[KYMARTIN]

I know there is a way to search for multiple instances of a value and return all of those instances separated by commas. I am wondering if there is a way to use VLOOKUP (or any other formula/VBA) to search for something like "English1,English2,English3" and return "Spanish1,Spanish2,Spanish3" from a lookup table with English 1 corresponding to Spanish1 and so forth.

 

[Eric W]

Welcome to the forum.

Take a look at:

https://www.mrexcel.com/forum/excel...iple-results-custom-function.html#post4980457

 

[KYMARTIN]

Welcome to the forum.

Take a look at:

https://www.mrexcel.com/forum/excel...iple-results-custom-function.html#post4980457

Thanks! This is exactly what I was looking for! I must have overlooked it when I tried to search the forum.

 

[Eric W]

Glad to help! The forum has gotten so big, it's easy to miss something like that. I spend waaay too much time here, so I remembered it!