Hi all,

I have a list of words in column A, several thousand rows long and I have a list of words in column B which is maybe 150 rows long.

I am trying to search column A for all instances of words that are in column B and if a word from column B exists in column A I want to copy it to column C or otherwise mark it so I know it's there.

Any help is appreciated.

Thanks