pulling data from one sheet to another

[Guest]

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.

 

[Guest]

Something like this ..
In Sheet2,
In B18: =IF(Sheet1!A22="single story system",Sheet3!B5,"")

 

[Guest]

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,"")

 

[Guest]

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

 

[Guest]

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

 

[Guest]

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?

 

[Max]

Try it with a TRIM wrapped around:
=IF(TRIM(Sheet1!A22)="single story system",Sheet3!B5,"")

 

[Guest]

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

 

[Gord Dibben]

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


Gord Dibben MS Excel MVP

 

[Guest]

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

 

[Gord Dibben]

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

 

[Guest]

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!

 

[Max]

Perhaps you mean something like this .. :
=IF(TRIM(Sheet1!A22)="single story
system",Sheet3!B5,IF(TRIM(Sheet1!A22)="double story system",Sheet3!B6,""))