Getting rid of n/a in Vlookup

  • Thread starter Thread starter Pinda
  • Start date Start date
P

Pinda

In a vlookup formula, how can you get excel to enter a
blank cell rather than #n/a, when the reference is not
contained within the range?

Thanks
 
Pinda said:
In a vlookup formula, how can you get excel to enter a
blank cell rather than #n/a, when the reference is not
contained within the range?

Thanks
Click to expand...

=IF(ISNA(yourlookupformula),"",yourlookupformula)
 
Try using it in conjunction with an "if" statement...

For example:

=if(isna(vlookup("cell","range","return",false)),"",vlookup
("cell","range","return",false))
 
Back
Top