Formula Not Returning Zero Values

[meppwc]

The formula below which is located in may places of my worksheet, populates all numbers that it finds from the Table worksheet unless the value in the Table is "0". What would cause that?
=IFERROR(VLOOKUP(F2,Table!$A:$AM,26,FALSE),IFERROR(VLOOKUP(H2,Table!$A:$AM,26,FALSE),0))

 

[Aladin Akyurek]

What do you get instead of a real 0 you expect to get?

 

[meppwc]

the cell is blank and I expect to see a "0".............note, the cell with a zero in it is not a calculated cell (no formula)...........it is a General field

 

[Rick Rothstein]

the cell is blank and I expect to see a "0".............note, the cell with a zero in it is not a calculated cell (no formula)...........it is a General field

Maybe you have the display of zeros turned off. Open up Excel Options, select the Advanced item and scroll down till you find the options for "this worksheet"... find the "Show a zero in cells that have zero value" checkbox and put a check in it, then OK back to the sheet. Do the zeros now show up?

 

[meppwc]

the settings are set to display zeros.

 

[Rick Rothstein]

the settings are set to display zeros.

Do you have a custom format set for the cell, in particular, this one General;General; perhaps?

Another possibility is that you may have a Conditional Format, one that hides zero, set for the cell.

 

[meppwc]

no custom or conditional formats set

 

[Rick Rothstein]

no custom or conditional formats set

The only other thing I can think of is if you have an event code procedure (either in the sheet's code module or the ThisWorkbook code module) set up for that cell. Failing that, I am out of ideas.

 

[Aladin Akyurek]

the cell is blank and I expect to see a "0".............note, the cell with a zero in it is not a calculated cell (no formula)...........it is a General field

Does this enforce what you want to obtain?

=IFERROR(N(VLOOKUP(F2,Table!$A:$AM,26,FALSE)),IFERROR(N(VLOOKUP(H2,Table!$A:$AM,26,FALSE)),0))

 

[meppwc]

That worked Aladin...........thanks so much !!!!
Not sure what the addition of "N" does though

Spoke too soon...........now all values are 0 in the entire column