pulling data from one sheet to another

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
Something like this ..
In Sheet2,
In B18: =IF(Sheet1!A22="single story system",Sheet3!B5,"")
 
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,"")
 
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
 
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?
 
Try re-formatting the cell as General then hit F2 and ENTER.


Gord Dibben MS Excel MVP
 
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
 
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!
 
Perhaps you mean something like this .. :
=IF(TRIM(Sheet1!A22)="single story
system",Sheet3!B5,IF(TRIM(Sheet1!A22)="double story system",Sheet3!B6,""))
 
Back
Top