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 matchSolved! Go to Solution.
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!