Find row after look up matching strings from

[Solved/Closed]
Report
Posts
16
Registration date
Tuesday June 1, 2010
Status
Member
Last seen
July 11, 2012
-
 j3kj3k -
Hello Experts,

I am looking for a way to find strings from <Sheet2> in <Sheet1> and put a flag (XXX) next cells.
Your help is greatly appreciated.

<Sheet1 - ColumnA>
Monkey has a banana
Tiger got nothing
Turky has an apple_nuts
Puppy has a bone but no sugar
Lion has a apple and a banana
But no one has apples and apples

<Sheet2 - ColumnA>
apple
banana

===> Result <======
<Sheet1 - Column A & B>

Monkey has a banana XXX
Tiger got nothing
Turky has an apple_nuts XXX
Puppy has a bone but no sugar
Lion has a apple and a bananaNuts XXX
But no one has apples&apples XXX


1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
2
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month

Many Thanks, rizvis1 'The Best'