Search 1 worksheet then another for data in large workbook

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

pignataro1@cox.net - 07 Dec 2007 21:40 GMT

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

Reply to this Message

excelent - 08 Dec 2007 08:19 GMT

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

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

"pignataro1@cox.net" 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.
[quoted text clipped - 6 lines]
>
> Thanks

Reply to this Message

excelent - 08 Dec 2007 08:21 GMT

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
[quoted text clipped - 13 lines]
> >
> > Thanks

Reply to this Message

pignataro1@cox.net - 10 Dec 2007 15:12 GMT

On Dec 8, 3:21 am, excelent <excel...@discussions.microsoft.com>
wrote:

> ups. Fejl=Error
>
[quoted text clipped - 21 lines]
>
> - 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

Reply to this Message

excelent - 10 Dec 2007 18:39 GMT

The formula is ok, works fine here

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

"pignataro1@cox.net" skrev:

> On Dec 8, 3:21 am, excelent <excel...@discussions.microsoft.com>
> wrote:
[quoted text clipped - 37 lines]
>
> Thanks

Reply to this Message