Cell formatting issue??

[taniab]

I have this formula

=VLOOKUP($A169,SSummarisedData!$11:$268,50,FALSE)

However when the cell is blank, sometimes it returns a 0 and other times it returns a blank.

I need to count any cells that are not blank or have a 0

If the cell has not data, it should return all 0's or all blanks (I don't really care) but it is returning either!

The problem is I can't count the non-blank fields using CountBlank, it won't recognise those cells for some reason. Is it something to do with formulas?

When I look at the data in the Lookup sheet, it all looks the same (blank) I can't work out why sometimes it returns 0 and sometimes blank.

In the example:
This formula
=VLOOKUP($A169,SSummarisedData!$11:$268,50,FALSE) returns a blank field
This formula returns a "0"
=VLOOKUP($A169,SSummarisedData!$11:$268,62,FALSE)

The cell numbers are at the top of the sheet for reference purposes in the attached pic

 

[LazyBug]

What about
=IF(LEN(VLOOKUP($A169,SSummarisedData!$11:$268,50,0))=0,"",VLOOKUP($A169,SSummarisedData!$11:$268,50,0))