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