Vlookup(ing) a null field is returning a 0

[Commander]

I have a monster spreadsheet that uses Vlookup extensively. I wonder if there is a way that if the cell I bringing over into my model is null, that I can get Vloolup to give me a null. As it stands I get a 0, which isn't really null.

I am hoping not to have to insert an IF statement into hundreds (thousands?) of vlookup statements.

Ideas?

Thanks in advance!
The Commander

[Bryan Hessey]

I have a monster spreadsheet that uses Vlookup extensively. I wonder if there is a way that if the cell I bringing over into my model is null, that I can get Vloolup to give me a null. As it stands I get a 0, which isn't really null.

I am hoping not to have to insert an IF statement into hundreds (thousands?) of vlookup statements.

Ideas?

Thanks in advance!
The Commander

HI,

In tools Options, View, untick Zero Values.

hth
---

[Commander]

Wow! Like a charm. Thank you very much!

[Bryan Hessey]

Wow! Like a charm. Thank you very much!

Good to see, but watch your true value fields if you need zero to display there.

Thanks for the response.
---