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

I have a 2 sheet workbook. If cell 'sheet1 b7' has a certain word typed into
it I want 'sheet2 b2' to return the value in 'sheet 1 b8'. Can I do this? How?
Thanx

Try the following formula in cell B2 of sheet2:

=IF(Sheet1!B7="aCertainWord",Sheet1!B8,"???")

Replace "aCertainWord" with your "certain word".
Replace "???" with what you want in the cell if the condition is not
fulfilled.

Hope this helps / Lars-Åke