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

Search 1 worksheet then another for data in large workbook
 

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

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


" skrev:

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

Search 1 worksheet then another for data in large workbook
 

ups. Fejl=Error

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

"excelent" skrev:

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

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


" skrev:

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

Search 1 worksheet then another for data in large workbook
 

On Dec 8, 3:21 am, excelent
wrote:
ups. Fejl=Error

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

"excelent" skrev:



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

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

" skrev:

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- Hide quoted text -

- 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

Search 1 worksheet then another for data in large workbook
 

The formula is ok, works fine here

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


" skrev:

On Dec 8, 3:21 am, excelent
wrote:
ups. Fejl=Error

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

"excelent" skrev:



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

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

" skrev:

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- Hide quoted text -

- 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