Link to home
Start Free TrialLog in
Avatar of sc456a
sc456a

asked on

Data Matching in Excel

I have two sets of data that I need to match up. Each set has a common denominator, but there aren't an equal number of records so I can't just sort the columns by those numbers to match them up.

For example, I've got one set like this:

data,111222
data4,223333

and another like this:

data2,111222
data5,223333

I just want a result that looks like the following, matched by the common number:

data,data2
data4,data5

Is there a way to make Excel match two sets of data based on numbers in columns that match and then output required data in the format listed above? Thanks!
ASKER CERTIFIED SOLUTION
Avatar of Ryan Chong
Ryan Chong
Flag of Singapore image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Professor J
Professor J

can you upload an example file?
Avatar of sc456a

ASKER

Worked perfectly! Thanks!