On Fri, 14 May 2010 12:15:01 -0700, Becky
wrote:

I have a two sheet workbook. If 'sheet 1 B7' contains a certain word I want
"Sheet2 B2' to return the value in 'Sheet 1 B8". Can I do this? How?
Thanx

Yes you can. Please see your other thread with the same question.

Lars-Åke