I have a workbook with multiple sheets. On one sheet, for cell a22 (which is
a thru g 22, merged), a value is entered, say 'single story system'. I want
another cell (say b18), on another sheet, to pull a value from a third cell
(say b5) on the third sheet, if cell a22 on the first sheet has 'single story
system' as its value.

I hope I have explained this clearly.

Something like this ..
In Sheet2,
In B18: =IF(Sheet1!A22="single story system",Sheet3!B5,"")
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"RPW" wrote:
I have a workbook with multiple sheets. On one sheet, for cell a22 (which is
a thru g 22, merged), a value is entered, say 'single story system'. I want
another cell (say b18), on another sheet, to pull a value from a third cell
(say b5) on the third sheet, if cell a22 on the first sheet has 'single story
system' as its value.

I hope I have explained this clearly.

max has the answer, I'll just add that if your sheet names have a space in
them, enclose the sheet names in the formula with single quote marks
(apostrophes) as

=IF('my Data sheet'!A22="single story system",'my Other Sheet'!B5,"")

"RPW" wrote:

I have a workbook with multiple sheets. On one sheet, for cell a22 (which is
a thru g 22, merged), a value is entered, say 'single story system'. I want
another cell (say b18), on another sheet, to pull a value from a third cell
(say b5) on the third sheet, if cell a22 on the first sheet has 'single story
system' as its value.

I hope I have explained this clearly.

This should do you,
In sheet 2 cell B18 type,

=IF(Sheet1!A22="single story system",Sheet3!B5,"")

If it doesn't say single story system in sheet 1 cell A22, B18 stays blank,
if it does it displays the value from sheet 3 cell B5


--
This post was created using recycled electrons!


"RPW" wrote:

I have a workbook with multiple sheets. On one sheet, for cell a22 (which is
a thru g 22, merged), a value is entered, say 'single story system'. I want
another cell (say b18), on another sheet, to pull a value from a third cell
(say b5) on the third sheet, if cell a22 on the first sheet has 'single story
system' as its value.

I hope I have explained this clearly.

Thank you to all three of you. You saved me a lot of work!

"Newbeetle" wrote:

This should do you,
In sheet 2 cell B18 type,

=IF(Sheet1!A22="single story system",Sheet3!B5,"")

If it doesn't say single story system in sheet 1 cell A22, B18 stays blank,
if it does it displays the value from sheet 3 cell B5


--
This post was created using recycled electrons!


"RPW" wrote:

I have a workbook with multiple sheets. On one sheet, for cell a22 (which is
a thru g 22, merged), a value is entered, say 'single story system'. I want
another cell (say b18), on another sheet, to pull a value from a third cell
(say b5) on the third sheet, if cell a22 on the first sheet has 'single story
system' as its value.

I hope I have explained this clearly.

OK, that did not work. I wonder if it is because the data in sheet one that
I am using comes from a drop down menu box.........any ideas?

"RPW" wrote:

Thank you to all three of you. You saved me a lot of work!

"Newbeetle" wrote:

This should do you,
In sheet 2 cell B18 type,

=IF(Sheet1!A22="single story system",Sheet3!B5,"")

If it doesn't say single story system in sheet 1 cell A22, B18 stays blank,
if it does it displays the value from sheet 3 cell B5


--
This post was created using recycled electrons!


"RPW" wrote:

I have a workbook with multiple sheets. On one sheet, for cell a22 (which is
a thru g 22, merged), a value is entered, say 'single story system'. I want
another cell (say b18), on another sheet, to pull a value from a third cell
(say b5) on the third sheet, if cell a22 on the first sheet has 'single story
system' as its value.

I hope I have explained this clearly.

Try it with a TRIM wrapped around:
=IF(TRIM(Sheet1!A22)="single story system",Sheet3!B5,"")
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"RPW" wrote in message
...
OK, that did not work. I wonder if it is because the data in sheet one
that
I am using comes from a drop down menu box.........any ideas?

when I enter that formula into the cell, and hit enter, the cell shows what I
typed, what am I doing wrong?

"Max" wrote:

Try it with a TRIM wrapped around:
=IF(TRIM(Sheet1!A22)="single story system",Sheet3!B5,"")
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"RPW" wrote in message
...
OK, that did not work. I wonder if it is because the data in sheet one
that
I am using comes from a drop down menu box.........any ideas?