Hi there,
Just wondering if anyone could assist me on the below exercise:
Table A has only Clean ID (123456789) or (414141)
Table B has column1, complex ID (**123456789*abc5489 or qwe*414141) and column 2 which is result I want to return (e.g. Rain, Sunny etc)
Would like to perform "vlookup" for Table A and search for items in table B column 1 only rows that contain EXACT string in table A and, if in such case, return value in column 2
So effective would see
ID..........................Results
123456789.........Rain
414141.................SunnySo far have tried:
a. standard merge - doesn't work as not exact match
b. merge with fuzzy match - doesnt work even threshold is 0.1, just doesnt return good results
c. List contain - doesnt work as it will list final table A each row so many times and return wrong values for some very weird reason..
d. interestingly, xlookup with ""&column A&"" does work .. but the data set 1 is around 1.5million rows and data set 2 is over 10millions rows so cant perform such xlookup
Highly appreciate for any suggestions!!
