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
|