Comparing data in sheet with another

  • Thread starter Thread starter Paul D
  • Start date Start date
P

Paul D

Hi
How do I do this?
In sheet1 column A are part no's, I want to compare this with the par
no's in sheet2 column A and if they are the same put the value fro
sheet 2 column D into the correct row on sheet 1 column D
I am using Excel 2002
Thanks for any hel
 
Paul D,

The Vllokup function will achieve this, however without knowing the
layout of your data I cannot be very specific.

Look in online help and have ago, if it is still a problem let the
forum know..
 
Paul:

VLOOKUP is the tool. I have assumed that the range of
sheet 2 is through row 25. I have also assumed that row
1 is a header row. Change this to meet your needs.

Put the following formula into cell D2 of sheet 1 and
copy down for each row:

=VLOOKUP(A2,Sheet2!$A$2:$D$25,4,FALSE)

Mike.
 
Back
Top