Search 1 worksheet then another for data in large workbook

[pignataro1]

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

 

[excelent]

Create a name for both cells (DI and Ware)
then use this formula to do the job

=IF(AND(DI<>"",Ware<>""),"Fejl",DI&Ware)


"(e-mail address removed)" skrev:

 

[excelent]

ups. Fejl=Error

=IF(AND(DI<>"",Ware<>""),"Error",DI&Ware)

"excelent" skrev:

 

[pignataro1]

ups. Fejl=Error

=IF(AND(DI<>"",Ware<>""),"Error",DI&Ware)

"excelent" skrev:




- Show quoted text -

Hi,
Still having an issue-formula reads:

=IF(AND('Pietra Majella DI'!$I$34<>"",'Pietra Majella Ware'!$I
$34<>""),"ERROR",DI&WARE)

But ERROR is the message I'm getting even though there is only 1 cell
that has info. It should be reading 2-error should only come up if
both Ware and DI cells are filled by mistake.

Suggestions?

Thanks

 

[excelent]

The formula is ok, works fine here

what do u have in these 2 cells
if formula then try paste them here


"(e-mail address removed)" skrev: