using vlookup with the false option for the range lookup which would give you an N/A if the item is not found. Then wrap it in an if(iserror) function to make the #N/A = to zero.