vlookup

kraway · May 3, 2006

When vlookup does not find the value, can I have it return a valeu of 0?
Maybe an "IF" statement?

Thanks for your help

Ardus Petus · May 3, 2006

IF(ISNA(VLOOKUP..),0,VLOOKUP(...))

HTH

Dave Peterson · May 3, 2006

something like:

=if(iserror(vlookup(...)),0,vlookup(...))