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!
Microsoft Excel

Avatar of undefined
Last Comment
sc456a

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Ryan Chong

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Professor J

can you upload an example file?
sc456a

ASKER
Worked perfectly! Thanks!
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck