VLOOKUP results showing as blank or 0

[Excel_VBA]

I have VLOOKUPs on a column. Some cells are blank. Some of those blank cells return a blank, but some return a 0. Why is this?

The cell format is General in all cases. I checked for the presence of spaces but there are not any. All blank cells are truly blank, but some return a blank, and some return a 0.

 

[T. Valko]

I have VLOOKUPs on a column. Some cells are blank. Some of those blank cells return a blank, but some return a 0. Why is this?

The cell format is General in all cases. I checked for the presence of spaces but there are not any. All blank cells are truly blank, but some return a blank, and some return a 0.

A truly empty cell will return 0.

Space characters aren't the only "whitespace" characters. There may be some other unseen character in the cell.

Find one of those cells and try this formula against it:

=CODE(cell_ref)

If you get a numeric result then that means there's something in the cell.

Might some of the cells in question contain formulas that return blanks "" ?

 

[Excel_VBA]

Might some of the cells in question contain formulas that return blanks "" ?

You are correct. My main formula is inside of an IFERROR function which will return a "" if the formula evaluates to an error. Thank you very much. I appreciate your insight.

 

[T. Valko]

You are correct. My main formula is inside of an IFERROR function which will return a "" if the formula evaluates to an error. Thank you very much. I appreciate your insight.

You're welcome. Thanks for the feedback!