IF(ISERROR help

[MOB]

I'm trying to do the following;

if vlookup1 returns an error, then vlookup2, if that returns an error then vlookup3, if that returns an error then return zero

Cant make it work!!

Any help would be appreciated

 

[Von Pookie]

Not entirely certain if it will work, but I believe you're looking for something like this

=IF(ISERROR(VLOOKUP1),IF(ISERROR(VLOOKUP2),IF(ISERROR(VLOOKUP3),0,VLOOKUP3),VLOOKUP2),VLOOKUP1)

Replace the VLOOKUP1-3 with your actual Vlookup, of course.
There may be (much) better ways to do this as well--I just don't know them.

 

[MOB]

Nearly works - I think my description wasn't exactly what I'm after though lol

What I really need it to do is this;

If vlookup1 isnt an error, then vlookup1, then
If vlookup2 isnt an error, then vlookup2, then
If vlookup3 isnt an error, then vlookup3, then 0


I think that may actually be easier, but I cant get it to work!!

 

[MOB]

I think I've got it to work with =if(not(iserror..........

But if there is a better way I'm all ears!

Thanks for your help.