#NA
 

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

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

"Alex H" wrote in message
...
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

Try:

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


Substituting your lookup data

Don Pistulka




"Alex H" wrote in message
...
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

Thanks

Alex

"KL" wrote in message
...
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

"Alex H" wrote in message
...
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