Match parts of strings in a lookup table and return another column

omezquita

New member
Joined
Apr 1, 2016
Messages
19
Reaction score
0
Points
0
Website
www.masterdataanalysis.com
Excel Version(s)
2016
Hi,

I have a column with texts:

Text Column.png

and I want to match parts of those strings with a lookup column in another table and return another column:
Lookup Table.png

The end result should look like this:
Result.png

Thanks!
 
You could append the original Table and then remove the duplicates??
 

Attachments

  • 7220 v2.xlsx
    20.4 KB · Views: 10
Back
Top