#NA

A

Alex H

I am creating a spreadsheet spreading forward for the next 12 months. Some
ofmy cells have #NA in them as there is no raw data for the vloopup to
calculate.

Is there a way to display a blank cell for these #NA's

Thanks

Alex
 
K

KL

Hi Alex,

Try something like this:

=IF(ISNA(VLOOKUP(A1,$B$1:$C$10,2,0)),"",VLOOKUP(A1,$B$1:$C$10,2,0))

or

=IF(ISERROR(VLOOKUP(A1,$B$1:$C$10,2,0)),"",VLOOKUP(A1,$B$1:$C$10,2,0))

Regards,
KL
 
D

Don

Try:

=IF(ISERROR(VLOOKUP(G8,A1:B10,2,FALSE)),"",VLOOKUP(G8,A1:B10,2,FALSE))


Substituting your lookup data

Don Pistulka
 
A

Alex H

Thanks

Alex

KL said:
Hi Alex,

Try something like this:

=IF(ISNA(VLOOKUP(A1,$B$1:$C$10,2,0)),"",VLOOKUP(A1,$B$1:$C$10,2,0))

or

=IF(ISERROR(VLOOKUP(A1,$B$1:$C$10,2,0)),"",VLOOKUP(A1,$B$1:$C$10,2,0))

Regards,
KL
Click to expand...
 
Top