From: Becky on
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
From: Rick Rothstein on
Something like this I would guess...

With Worksheets("Sheet1")
If .Range("B7") = "certain word" Then
Worksheets("Sheet2").Range("B2").Value = .Range("B8").Value
End If
End With

--
Rick (MVP - Excel)



"Becky" <Becky(a)discussions.microsoft.com> wrote in message
news:F7422B7D-BF3F-4B12-9790-FCA111E960EA(a)microsoft.com...
> 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

From: DB on
How about:
=IF(Sheet1!B7="certain",Sheet1!B8,"wrong word")

"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
From: Dave Peterson on
Check your other post.

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