#1
|
|||
|
|||
Excel 2010 Functions
I am trying to figure out how I could create an equation for a cell where it will pull data from other sheets that are in the same excel file. In other words I have a template that is one sheet and in a cell on that sheet I am pulling data from sheet 2. But I still have a sheet 3 and 4. So if the cell where I am pulling it from in sheet 2 is empty I want it to be able to pull from either sheet 3 or 4. I am not sure if this would be an "IF" statement of what |
#2
|
|||
|
|||
Are you aiming to pull information from sheets 2 to 4 conditionally or the aggregate of all cells containing data? Is the data text or numerical?
|
#3
|
|||
|
|||
the data is text.
Sheet 1: Template Sheet 2 Sheet 3 Sheet 4 the information that I am wanting to pull will be from the same cell in sheet 2, sheet 3 and sheet 4. I am just wanting to make sure it pulls data from one of the sheets and stores it in the template. sheets 2-4 will have the same information but sometimes sheet 2 will be blank so I am wanting to then go to the next sheet to pull that data |
#4
|
|||
|
|||
=IF(ISBLANK(Sheet2!A1),IF(ISBLANK(Sheet3!A1),IF(IS BLANK(Sheet4!A1),"What the heck, no data!",Sheet4!A1),Sheet3!A1),Sheet2!A1)
This will return the value, text or otherwise, from Sheet2 unless nothing is there. Then it will do the same for Sheet3 and Sheet4. If there is data in more than one sheet, it will return it from the "lowest" sheet and the others are ignored. If none have data, it returns a snarky comment. |
#5
|
|||
|
|||
thank you gebobs!
|
#6
|
|||
|
|||
What about if sometimes there isn't a sheet 2 but sometimes there are
|
#7
|
|||
|
|||
Don't know what to tell you. If you don't know what sheets you have, you can't write an equation that refers to them.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Conditional Fields With String Functions, Office 2010 | thpanos | Word | 6 | 02-16-2013 08:56 AM |
2010 Functions Don't Work | PaulPCoker | Excel | 4 | 09-21-2012 11:26 AM |
Word 2010 - F4/Ctrl+Y functions has short memory | alphonse68 | Word | 1 | 01-09-2012 03:34 PM |
** Using Functions | djreyrey | Excel Programming | 10 | 02-08-2011 04:18 PM |
Automated Functions?? | nickypatterson | Outlook | 0 | 08-27-2009 01:50 PM |