Matching words from 3 different columns against 1 column

[ben_d_jacob]

Hi everyone, 

I would like to check if the Words (not characters) from column 1, column 2 and column 3 are in column A and it should not match null values.

Can you please suggest a method to do this.

I might not be able to share the screenshot as it is classified data

so, the columns 1,2 & 3 should look for values in column A as words...for example, in column 1 there is a word INT and in the same row in column A the word is INTERNATIONAL...this should not be a match

[ben_d_jacob]

The logic here is correct. I got the output with a little tweak in this ...instead of a filter tool, I used a formula tool, and instead of adding the space to the string, I added the space to the target...and this worked for me...thank you all so much!!

This community is really amazing! Has pulled me out of many such situations!