vlookup

[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?

 

[akphidelt]

Check to see if the vlookup shows up as an error... so it would look like this

=If(Iserror(Vlookup()),"",Vlookup())

 

[Dave Peterson]

=if(isna(vlookup(...)),"",if(vlookup(...)="","",vlookup(...))))

or

=if(iserror(1/len(vlookup(...)),"",vlookup(...))

And xl2007 has added an =iferror(), too.

 

[HJ]

It's not showing up as an error, it is pulling the wrong information. ?

 

[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.