vlookup
 

is there a way for a vlookup formula to return a blank cell if it is unable
to find a match in the list?

vlookup
 

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

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

"HJ" wrote:

is there a way for a vlookup formula to return a blank cell if it is unable
to find a match in the list?

vlookup
 

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

or

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

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

HJ wrote:

is there a way for a vlookup formula to return a blank cell if it is unable
to find a match in the list?

--

Dave Peterson

vlookup
 

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

"akphidelt" wrote:

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

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

"HJ" wrote:

is there a way for a vlookup formula to return a blank cell if it is unable
to find a match in the list?

vlookup
 

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.

"HJ" wrote:

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

"akphidelt" wrote:

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

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

"HJ" wrote:

is there a way for a vlookup formula to return a blank cell if it is unable
to find a match in the list?