Your formula makes no sense.

The item to look up is within the lookup Range.

If it does return zero you could turn off zero values. Goto Tools > options > edit tab > untick zeros

or use an if statement

=IF(VLOOKUP($E29,$B:$E,2,0)=0,"",VLOOKUP($E29,$B:$E,2,0))
http://spreadsheetpage.com/index.php...s_in_formulas/

VBA Noob