| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Search 1 worksheet then another for data in large workbook
Trying to write a formula to go to first worksheet look if there are
any numbers or words and if not go to next worksheet and do the same. If both are empty, then the cell should be left blank. If one or other has info then that should be result, if both have info then put ERROR in cell. This is returning #VALUE =IF(AND('Pietra Majella DI'!$I$34=0),AND,OR('Pietra Majella Ware'!$I $34)) Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I need an Equation in a cell to search a workbook not worksheet | Excel Worksheet Functions | |||
| How do I search for data in a large worksheet? | Excel Discussion (Misc queries) | |||
| make large worksheet from workbook | Excel Discussion (Misc queries) | |||
| Need to search workbook for NEW worksheet | Excel Programming | |||
| Attaching a JET database to an Excel Worksheet OR storing large binary data in a worksheet | Excel Programming | |||
Threaded Mode
