I have sheet1 and sheet2 both sheets have same data but there are some new
material # in sheet1.

Problem is when apply Vlookup formula in sheet2 then quantities of new
material numbers do not comes because these new materials numbers do not
exist in sheet2.

Is there any method? To trace new or diff. materials numbers those are
exist in sheet1

Regards

Zafar