How could I search each comma separated value in a cell, then find a match to it's value from another workbook?
datalookup.xlsx
A - value to match search
B - value to be returned correspondent to match
seachmatch.xlsx
C - search each comma separated value until found a match on [datalookup.xlsx]sheet!$A, and return corresponded value of [datalookup.xlsx]sheet!$B
D - Returned value (result)
Note: C value could go over 256 characters.
Thanks in advance.
datalookup.xlsx
A - value to match search
B - value to be returned correspondent to match
seachmatch.xlsx
C - search each comma separated value until found a match on [datalookup.xlsx]sheet!$A, and return corresponded value of [datalookup.xlsx]sheet!$B
D - Returned value (result)
Note: C value could go over 256 characters.
Thanks in advance.