pulling data from one sheet to another
 

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.

pulling data from one sheet to another
 

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.

pulling data from one sheet to another
 

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.

pulling data from one sheet to another
 

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.

pulling data from one sheet to another
 

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.

pulling data from one sheet to another
 

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.

pulling data from one sheet to another
 

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?

pulling data from one sheet to another
 

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?

pulling data from one sheet to another
 

Try re-formatting the cell as General then hit F2 and ENTER.


Gord Dibben MS Excel MVP

On Fri, 16 Feb 2007 08:12:07 -0800, RPW wrote:

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?

pulling data from one sheet to another
 

YES!!!!!!! I am so excited. Thank you so much. By the way, what does the F2
do? Thanks again!

"Gord Dibben" wrote:

Try re-formatting the cell as General then hit F2 and ENTER.


Gord Dibben MS Excel MVP

On Fri, 16 Feb 2007 08:12:07 -0800, RPW wrote:

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?

pulling data from one sheet to another
 

F2 puts you into cell Edit mode.

So in essence you are editing the cell contents even though you changed nothing.

Same as double-clicking the cell or clicking in the formula bar.


Gord Dibben MS Excel MVP

On Fri, 16 Feb 2007 09:50:00 -0800, RPW wrote:

YES!!!!!!! I am so excited. Thank you so much. By the way, what does the F2
do? Thanks again!

"Gord Dibben" wrote:

Try re-formatting the cell as General then hit F2 and ENTER.


Gord Dibben MS Excel MVP

On Fri, 16 Feb 2007 08:12:07 -0800, RPW wrote:

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?

pulling data from one sheet to another
 

I know I am pushing my luck, but if I wanted to add a second condition to
that cell, another =IF(TRIM( etc., how would I do that? Thank you!

"Gord Dibben" wrote:

F2 puts you into cell Edit mode.

So in essence you are editing the cell contents even though you changed nothing.

Same as double-clicking the cell or clicking in the formula bar.


Gord Dibben MS Excel MVP

On Fri, 16 Feb 2007 09:50:00 -0800, RPW wrote:

YES!!!!!!! I am so excited. Thank you so much. By the way, what does the F2
do? Thanks again!

"Gord Dibben" wrote:

Try re-formatting the cell as General then hit F2 and ENTER.


Gord Dibben MS Excel MVP

On Fri, 16 Feb 2007 08:12:07 -0800, RPW wrote:

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?

pulling data from one sheet to another
 

Perhaps you mean something like this .. :
=IF(TRIM(Sheet1!A22)="single story
system",Sheet3!B5,IF(TRIM(Sheet1!A22)="double story system",Sheet3!B6,""))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"RPW" wrote in message
...
I know I am pushing my luck, but if I wanted to add a second condition to
that cell, another =IF(TRIM( etc., how would I do that?