| Home |
| Search |
| Today's Posts |
|
#3
|
|||
|
|||
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 |
Threaded Mode
