I have a table (aRange) with a blank Cell

eg.

5 r Some Value which could be 0

3 f

4 t Some Value which could be 0

When my vlookup formula <=VLOOKUP(3,aRange,3,FALSE

)> refers to said blank cell it returns 0 instead of ""

The values in the column could be 0 so work around

<=IF(VLOOKUP(3,aRange,3,FALSE)<>0,VLOOKUP(3,aRange,3,FALSE),"")>

is not acceptable

Short of writing my own UDF how do I make vlookup behave as I believe it should ie return ""

If theres no answer apart from the UDF has anyone done one already to save me wasting time?

See the example if the above is not clear

Thanks in advance.

vlookup-Issue.xls