|
|
|
|
#1
07-02-2014, 05:51 AM
|
|||
|
|||
=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. 
|
|
|
|
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 |
Windows 7 64bit 
Office 2010 64bit
Hybrid Mode