Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP
Thanks to all for your responses - but I don't seem to have it quite
right. This is my formula:
=IF(=ISERROR(=VLOOKUP(I4,FUEL!$G$2:$I$2044,2,FALSE )),0,=VLOOKUP(I4,FUEL!$G$2:$I$2044,2,FALSE))
but I'm getting a message that the formula contains an error. I can't
see what's wrong...I must have mismatched parens or something. If
anyone can see what's wrong, I'd appreciate your letting me know. Many
thanks.
Conan Kelly wrote:
Yes it can,
=IF(ISERROR{or other IS functions}(VLOOKUP([your vlookup arguments])),0,VLOOKUP([your vlookup arguments]))
I hope this helps,
Conan Kelly
"buffgirl71" wrote in message ups.com...
I am using VLOOKUP and when that function doesn't find the value in the
table, it returns "#NA" as the value. I then can't sum the column
because of the #NA in some of the cells. Is there a way that I can
return a zero or a null instead of the #NA? I was thinking that perhaps
the VLOOKUP could be combined with IF... Thanks for your help in
advance.
|