VLOOKUP Error N/A

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

 

[trevosef]

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?

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

 

[JE McGimpsey]

One way:

=IF(ISNA(MATCH(A1,J:J,FALSE)),"",VLOOKUP(A1,J:K,2,FALSE))