Type this formula in B2 of Sheet2:

=if(countif(Sheet1!b7,"*"&"certain"&"*")=0,"",shee t1!b8)

=countif() will treat the * as a wild card. So "certain" could be anywhere in
that B7 Cell.

On 05/14/2010 14:16, 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