comparing 2 sheets

  • Thread starter Thread starter keyur
  • Start date Start date
K

keyur

hi!

k, this is wht i have
sheet1 (short list of about 400 parts with no descripiton)
columns - part # description

sheet2(complete list of about 2000 parts with description)
same columns - part # description


now is there a way that excel can compare a part # from
sheet 1 to that of sheet 2 and then fill the corresponding
description.

if you can help will save me hours of boring work.

thanks a lot!!
 
Hi keyur

in sheet 1, column B (description) enter the following in B2:
=VLOOKUP(A2,'sheet 2'!$A$1:$B$9999,2, FALSE)
copy this for all rows in sheet 1

HTH
Frank
 
Back
Top