I have a list of comma delimited text that I would like to VLOOKUP the values of, preferably without using Text-to-Columns. I would like to use VLOOKUP so that if there is an error I can return "Error".
Sheet 1 is my lookup list.
<tbody>
NUMBER
NAME
<tbody>
C-1032-4
</tbody>
<tbody>...