Hi, I need a macro to perform mass lookups in excel. The data to be looked up is in column A, while the reference tables are in columns D-E.
Problem is that there are multiple lookup values within one cell itself (refer to image), where the values are separated by "/".
Is there a way to do this in excel as the dataset is very large? Thanks.
Problem is that there are multiple lookup values within one cell itself (refer to image), where the values are separated by "/".
Is there a way to do this in excel as the dataset is very large? Thanks.
Attachments
-
40 KB Views: 37