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
The simplest solution is to make sure your lookup table doesn't contain empty cells.
Select the cells in the lookup table.
Choose Find & Replace (Ctrl+H)
Don't enter anything in the Find box.
In the Replace box put
=""
This will return "" rather than 0