Sample Data:
Sheet 1 B7 a
Sheet 1 B8 b
Sheet 2 B2 formula to be entered
Enter =IF(a="enter the word you are looking for",b8,"") This will give you
the value in B8 if it B7 contains the word you want. If not, it will return
Null or nothing. If you want it to return "Not Found" for example, the
formula would be
=IF(a="enter the word you are looking for",b8,"Not Found")

"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