More help with Formulas

  • Thread starter Thread starter Iain Wicks
  • Start date Start date
I

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
 
If you want it to display 0, use this:

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

Andy
 
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
 
Back
Top