Thread
:
How to make LOOKUP give zero if it can't find the lookup_value?
View Single Post
#
2
[email protected]
Posts: n/a
I usually use something like this:
=if(ISNA(vlookup(A,B,C),0,vlookup(A,B,C))
Where A,B,C are the arguments of the vlookup. I usually use "" (open
quote, close quote) in place of the 0, to give me a blank response.
Reply With Quote