Removing "0's" in V Lookups.

[Excel_77]

Hi All,

I have the following code in place which work, however if the search finds an empty cell it return "0" but I want it to be blank instead, how can I adjust the following formula?


=IFERROR(VLOOKUP(A4,test!$A$1:$L$108,12,FALSE),"")

Thanks in advance

 

[Aladin Akyurek]

Assuming that the L range is text, not numeric...

=IFERROR(T(VLOOKUP(A4,test!$A$1:$L$108,12,FALSE)),"")