 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / February 2007pulling 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. Something like this .. In Sheet2, In B18: =IF(Sheet1!A22="single story system",Sheet3!B5,"")  SignatureMax Singapore http://savefile.com/projects/236895 xdemechanik --- > 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 [quoted text clipped - 3 lines] > > 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,"") > 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 [quoted text clipped - 3 lines] > > 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 SignatureThis post was created using recycled electrons! > 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 [quoted text clipped - 3 lines] > > I hope I have explained this clearly. Thank you to all three of you. You saved me a lot of work! > This should do you, > In sheet 2 cell B18 type, [quoted text clipped - 11 lines] > > > > 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? > Thank you to all three of you. You saved me a lot of work! > [quoted text clipped - 13 lines] > > > > > > I hope I have explained this clearly. Try it with a TRIM wrapped around: =IF(TRIM(Sheet1!A22)="single story system",Sheet3!B5,"") SignatureMax Singapore http://savefile.com/projects/236895 xdemechanik --- > 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 it with a TRIM wrapped around: > =IF(TRIM(Sheet1!A22)="single story system",Sheet3!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? Try re-formatting the cell as General then hit F2 and ENTER. Gord Dibben MS Excel MVP >when I enter that formula into the cell, and hit enter, the cell shows what I >typed, what am I doing wrong? [quoted text clipped - 4 lines] >> > that >> > I am using comes from a drop down menu box.........any ideas? YES!!!!!!! I am so excited. Thank you so much. By the way, what does the F2 do? Thanks again! > Try re-formatting the cell as General then hit F2 and ENTER. > [quoted text clipped - 8 lines] > >> > that > >> > I am using comes from a drop down menu box.........any ideas? 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 >YES!!!!!!! I am so excited. Thank you so much. By the way, what does the F2 >do? Thanks again! [quoted text clipped - 11 lines] >> >> > that >> >> > I am using comes from a drop down menu box.........any ideas? 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! > F2 puts you into cell Edit mode. > [quoted text clipped - 19 lines] > >> >> > that > >> >> > I am using comes from a drop down menu box.........any ideas? Perhaps you mean something like this .. : =IF(TRIM(Sheet1!A22)="single story system",Sheet3!B5,IF(TRIM(Sheet1!A22)="double story system",Sheet3!B6,"")) SignatureMax Singapore http://savefile.com/projects/236895 xdemechanik --- >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? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.