Find row after look up matching strings from

Solved/Closed
j3kj3k
Posts
16
Registration date
Tuesday June 1, 2010
Status
Member
Last seen
July 11, 2012
- Jul 28, 2010 at 04:26 PM
 j3kj3k - Jul 29, 2010 at 01:35 AM
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

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
770
Jul 28, 2010 at 05:53 PM
2
Many Thanks, rizvis1 'The Best'
0