Hi all,

I spent the better part of 3 hours today trying to solve this on my own, so sorry to have to come crawling for direct help! Here's my problem i hope you experts can help with...

-- I have a spreadsheet with 2 sheets in it "Negatives" and "Report".

-- I'd like to search Column A of the Negatives sheet for the contents of Column B of the Report sheet.

-- I would then like to place in Column C of the Negatives sheet the entry it matched from Column B of the Report sheet.

-- The cells will not match exactly, so I need to be able to search within the cells of Column A of the Negatives sheet.

-- And there are hundreds of entries in each column of both sheets.

To Illustrate:

Negatives Sheet:
A1 contains "on a park bench"
A2 contains "with chicken salad"
A3 contains "tea for two"

C1 is blank
C2 is blank
C3 is blank

Report Sheet:
B1 contains "salad"
B2 contains "tea"
B3 contains "grass"

My desired result would be:

Negative Sheet:
A1 contains "on a park bench"
A2 contains "with chicken salad"
A3 contains "tea for two"

C1 is blank
C2 changed to "salad"
C3 changed to "tea"


I hope that's comprehensive and clear enough for someone to understand what i'm hoping for!

Thank you!