I have a workbook that checkes a single column and does a Vlookup for a single value in one cell. I need to do macro that will do a lookup of multiple comma separated values in one cell and return the vlookups for each value within the comma separation into another single cell in my excel sheet. Does anyone know how I could do that?
blue, green, orange
I need the Vlookup to look at a list on a separate sheet which has a 2 column table with the colors in one column and the id numbers in the column right next to it
colors ID number
and return the values
if they mistype the color I would expect to see the N/A in it:
then they should get 10783,#NA