can lookup return err if no match found
It works, it works, it works. Wish I had posted this question before I spent
so much time on it. Thank you very, very much.
"Kleev" wrote:
use the false argument:
=VLOOKUP(A14, Sheet4!$A$66:$B$70, 2, FALSE)
if no match, it will return #N/A
"Kim Greenlaw" wrote:
If lookup doesn't find a match in the first column, can I get it to return an
"ERR" or "0", something that would let me know there was no match? Right now
it returns the value in the second column of the closest value.
|