Comparing data in sheet with another

[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

 

[Kieran]

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..

 

[Mike]

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.