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
http://spreadsheetpage.com/index.php...s_in_formulas/=IF(VLOOKUP($E29,$B:$E,2,0)=0,"",VLOOKUP($E29,$B:$E,2,0))
VBA Noob
Bookmarks