matching / sorting two sets of data

willmrk

New Member
Joined
Nov 13, 2002
Messages
5
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.
 

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

Zack Barresse

MrExcel MVP
Joined
Dec 9, 2003
Messages
10,881
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
  2. Mobile
  3. Web
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
ABCD
1Serial#Model#Ageinmonths
210003A-100-BH5
310005B-345-AF10
410006A-100-BH10
510009B-345-AF2
610236Z-890-ZB6
710455X-777-JC8
811002A-100-BH2
912601Z-890-ZB14
1013205B-345-AF12
1113844A-100-BH6
1219090B-345-AF15
1319254X-777-JC2
1423001A-100-BH8
1530215A-100-BH18
1640404Z-890-ZB12
1750505A-100-BH10
1851342B-345-AF6
1960405A-100-BH2
2061257A-100-BH5
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
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,152,091
Messages
5,768,039
Members
425,451
Latest member
JohnBrooksBiddle

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top