VLOOKUP value refering to an Empty Cell

J

JJ

I have a vlookup formula in a cell refering to an empty cell giving me #N/A
but what do I have to do to get a 0 value.?

Tx
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VLOOKUP 2
Excel formula won't work (if, match, iserr, vlookup) 2
Excel Need Countifs Formula Help 0
Vlookup result in a message box 10
Excel formula, sum the value cell and if empty cell left blank 0
Vlookup Help 5
Trying to run excel vba code when cell value changes from empty to entered value. 1
Set add function ignore #N/A 1

Top