Comparing two values in different worksheets and extracting value

[Guest]

Hello,

I have the following problem with which I need some help:

I have two different worksheets with article numbers and quantity data. One
of these includes the whole set of articles, while the other holds only a
selection of articles. I need to compare the article numbers and extract a
value from another column in the first worksheet when these article numbers
match. E.g.:

worksheet 1
article number quantity
12345 12
98765

worksheet 2
article number
12345

I want to extract the quantity number from worksheet 1 into worksheet 2,
only for the matching article numbers.

Many thanks

Regards,

Ben

 

[RagDyeR]

Sheet1
Article number = Column A
Qty = Column B

Sheet2
Article number = Column A
Enter this formula in B2:

=IF(ISNA(MATCH(A2,Sheet1!$A$2:$A$50,0)),"",VLOOKUP(A2,Sheet1!$A$2:$B$50,2,0)
)

And drag down to copy.
This will leave an empty cell if there are no matches found in Column A.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


Hello,

I have the following problem with which I need some help:

I have two different worksheets with article numbers and quantity data. One
of these includes the whole set of articles, while the other holds only a
selection of articles. I need to compare the article numbers and extract a
value from another column in the first worksheet when these article numbers
match. E.g.:

worksheet 1
article number quantity
12345 12
98765

worksheet 2
article number
12345

I want to extract the quantity number from worksheet 1 into worksheet 2,
only for the matching article numbers.

Many thanks

Regards,

Ben