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?

On Dec 11, 1:42 pm, Hamed parhizkar
wrote:
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

One way:

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

In article ,
Hamed parhizkar wrote:

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?