Hello, I searched the forum and there are a few threads addressing this question but not sure if it works for me.
See attached. I have 2 sheets - one with the data and one with matching words.
I would like to match the words from 'List' sheet with col1 in 'Data' sheet. If an exact match is found anywhere in the string I would like the word from the list be populated in col2 of data sheet.
I have also used formulas I gathered from the forum in formula columns in data sheet.
Would appreciate your input.
Bookmarks