H
HJ
is there a way for a vlookup formula to return a blank cell if it is unable
to find a match in the list?
to find a match in the list?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
akphidelt
Check to see if the vlookup shows up as an error... so it would look like this
=If(Iserror(Vlookup()),"",Vlookup())
=If(Iserror(Vlookup()),"",Vlookup())
D
Dave Peterson
=if(isna(vlookup(...)),"",if(vlookup(...)="","",vlookup(...))))
or
=if(iserror(1/len(vlookup(...)),"",vlookup(...))
And xl2007 has added an =iferror(), too.
or
=if(iserror(1/len(vlookup(...)),"",vlookup(...))
And xl2007 has added an =iferror(), too.
H
HJ
It's not showing up as an error, it is pulling the wrong information. ?
D
Dave
Hi,
If your VLOOKUP is returning the wrong information, you've probably omitted
the 4th argument. If you don't put in the 4th argument as ,FALSE then if
VLOOKUP doesn't find what you've asked for, it just goes for the closest
match.
If you do put in the ,FALSE then if VLOOKUP can't find what you've asked
for, it will return an error, which you can use as described in the other
replies.
Regards - Dave.
If your VLOOKUP is returning the wrong information, you've probably omitted
the 4th argument. If you don't put in the 4th argument as ,FALSE then if
VLOOKUP doesn't find what you've asked for, it just goes for the closest
match.
If you do put in the ,FALSE then if VLOOKUP can't find what you've asked
for, it will return an error, which you can use as described in the other
replies.
Regards - Dave.