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