I'm working with 2 columns of data, the first column will always be the same and the second column will always be different. I'm trying to get the third column to partial match (6 characters) column 2 to the column 1 data. I can get it to work if there's exact matches in column 2 but not for partials
Any help appreciated, thanks!
Example excel file attached.
Bookmarks