matching / sorting two sets of data

[willmrk]

I have a worksheet with information about a number of stereos on it.

In Column A is a list of 500 serial numbers of stereos
In Column B is the list of model numbers of those stereos

In another worksheet I have more info about more stereos (some of which are also found in the other worksheet).

In Column A is a of 800 list of serial numbers (again, some of which are duplicates from the other worksheet).
In column B I have the Ages of those stereos.

Is there an easy way to compile these two worksheets together so in Column A will be the serial number, Column B have the model numbers, and column C have the ages?

You help would be greatly appreciated. This is something I have to do fairly often and it really seems as if there would be an automated method of doing it.

 

[Zack Barresse]

well if you mean that the duplicates exist on other sheets, and not the same one - i was a little confused about that part - then something like this...

Book3
	A	B	C	D
1	Serial#	Model#	Ageinmonths
2	10003	A-100-BH	5
3	10005	B-345-AF	10
4	10006	A-100-BH	10
5	10009	B-345-AF	2
6	10236	Z-890-ZB	6
7	10455	X-777-JC	8
8	11002	A-100-BH	2
9	12601	Z-890-ZB	14
10	13205	B-345-AF	12
11	13844	A-100-BH	6
12	19090	B-345-AF	15
13	19254	X-777-JC	2
14	23001	A-100-BH	8
15	30215	A-100-BH	18
16	40404	Z-890-ZB	12
17	50505	A-100-BH	10
18	51342	B-345-AF	6
19	60405	A-100-BH	2
20	61257	A-100-BH	5
Sheet1

as the formula suggests, my information was in Sheet2!A2:B20 in the format you specified.

this will need to be re-done if the duplicates are in the same sheet. if they are, are they exactly the same? case and all?

anyway, HTH