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 response

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