Prev: conditional count
Next: Sorting in a Pivot Table unselected fields
From: Becky on 14 May 2010 15:09
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
From: Lars-�ke Aspelin on 14 May 2010 15:15
On Fri, 14 May 2010 12:09:01 -0700, Becky
<Becky(a)discussions.microsoft.com> 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
From: Nadine on 14 May 2010 15:21
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
 | 
Pages: 1
Prev: conditional count
Next: Sorting in a Pivot Table unselected fields