In sheet2 cell B2 enter the formula

=IF(Sheet1!B7="certain word",Sheet1!B8,"")

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"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