More help with Formulas

[Iain Wicks]

Hi again, I think I have a more complicated issue than I
first realised.
I am now using this formula

=IF(ISERROR(Lookups!B1),Lookups!B2,Lookups!B1)

To reference fields from a different worksheet, as you
can see I am testing the first field for an error (#N/A)
Then if it is an error going down to the next field, but
if no error it will display the tested field.

BUT... If Lookups!B2 contains #N/A it now displays that
error. I think i want it to test this field as well
don't I? Is this possible?

Please help if any ideas

Regards

Iain

 

[Andy B]

Iain

What do you want it to display if both of the fields are errors?

Andy

 

[Andy B]

If you want it to display 0, use this:

=IF(ISERROR(Lookups!B1),IF(ISERROR(Lookups!B2),0,Lookups!B2),Lookups!B1)

Andy

 

[Iain Wicks]

Andy
I want it to display nothing and to keep going down until
it finds a relevant value. So that if all of the fields
are errors I would see nothing.

Hope that makes sense

Iain