Not sure whether I have understood your query correctly.

Try the below formula which will lookat Sheet1 and return whether the
material # exists in Sheet1 or not...Reoplace the exist comment with your
VLOOKUP() formula....

=IF(ISNA(MATCH(A1,Sheet1!A:A,0)),"New material number","Exist. Use a formula")

--
Jacob (MVP - Excel)


"vlook fomula" wrote:

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