# How to copy blanks from one sheet to another? [closed]

A cell in one workbook has a VLOOKUP formula that yields empty.

When I copy that cell and paste special into a second workbook (different file) I can't get the blank to come through - it's translated into a zero.

A zero and a blank mean completely different things in this dataset. I need a way to do this. For my purposes, a blank can be represented as a ZLS "", because it's going to get exported as CSV anyway.

Example sheet:

```
A1: =VLOOKUP("foo",B1:C2,2,0)
B1: foo
```

- A1 is blank (because the vlookup returns blank cell C1).
- Copy A1
- Paste-special somewhere else, without formula. You get a zero

Please try: with

`=ISBLANK(VLOOKUP("foo",B1:C2,2,0))`

in both files, to verify if the cell obtained with VLOOKUP is empty on both.The

`ISBLANK(VLOOKUP())`

returns TRUE, however`ISBLANK(A1)`

(put this in another cell on the demo sheet) returns FALSE.`TYPE(A1)`

return 8 which means formula. I think that this is a bug.