I have two columns of data — id's and data values. I can get vlookup to work if I want to return the correct fruit if I provide an id, but I need to also be able to account for cases where multiple values are provided as well.

Put another way, I need to be able to run my vlookup on each item in a comma-separated list in another cell.