vlookup
 

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

Thanks for your help

vlookup
 

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

HTH
--
AP

"kraway" a écrit dans le message de news:
...
When vlookup does not find the value, can I have it return a valeu of 0?
Maybe an "IF" statement?

Thanks for your help

vlookup
 

something like:

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



kraway wrote:

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

Thanks for your help

--

Dave Peterson