VLOOKUP Error N/A

  • Thread starter Thread starter Hamed parhizkar
  • Start date Start date
H

Hamed parhizkar

When using a vlookup formula and you do not yet have a number in the cell the
formula is referring to an N/A shows in the cell. How can you make that cell
just show a blank instead of N/A?
 
When using a vlookup formula and you do not yet have a number in the cell the
formula is referring to an N/A shows in the cell. How can you make that cell
just show a blank instead of N/A?
Click to expand...

Hi Hamed,

Change the formula to IF(ISNA(VLOOKUP....)," ",(VLOOKUP...)). If the
value is N/A, then it shows blank, otherwise, it picks up the value
from the VLOOKUP.

Hope this helps.

Regards
trevosef
 
Back
Top