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