View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] pignataro1@cox.net is offline
external usenet poster
 
Posts: 21
Default 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