ExcelBanter - VLOOKUP Error N/A

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - VLOOKUP Error N/A (https://www.excelbanter.com/excel-programming/402552-vlookup-error-n.html)

Hamed parhizkar

VLOOKUP Error 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?

[email protected]

VLOOKUP Error 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

JE McGimpsey

VLOOKUP Error N/A

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?

All times are GMT +1. The time now is 01:05 PM.