Good morning,
Is it possible to perform a lookup on a delimited field?
See the picture below. I want to perform a lookup in cell B1 which takes all the values from cell A1 and performs a lookup on the table E1:F4 & return the value in column F
Example.JPG
The desired output in cell B1 would be as follows;
Result1, Result 2, Result 4
Thanks in advance
David
Bookmarks