VLOOKUP: Why do I get "0" instead of #N/A or #REF???

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am running a VLOOKUP in a table with nearly 30,000 lines. Some of the
cells are kicking back valid data, some are kicking back #N/A (because there
is no corresponding infor to lookup), and then some are kicking back a 0
(zero) when 0 is not an option.

Why am I getting a 0? It does not say this is an error...
 
What is the formula in the cells that give 0?
How is the table organised - is the first column sorted or not.

Bill Manville
MVP - Microsoft Excel, Oxford, England
 
It's the same formula in all the cells: =VLOOKUP(B1327,'NGO
changes'!$C$2:$J$10487,6,FALSE)

The referenced table is nto sorted but it shouldn't have to be...it worked
for some cells and not others.
 
No obvious reason.

I wonder if you have a circular reference that is preventing the
calculation chain from completing (so the 0s are not the result of the
formula at all).

Check the statusbar to see if it says "Circular".

Bill Manville
MVP - Microsoft Excel, Oxford, England
 
Unexpected 0 is usually the result of VLOOKUP finding a blank cell in which
case it returns 0. Is this the case here?
 
Back
Top