Solved

EXCEL 2010 - Match two columns

Posted on 2013-01-07
7
1,846 Views
Last Modified: 2013-01-07
I have two columns of data, both columns have some matching values. I need to match these up. So basically I a trying to have Excel use Column A as a reference, then match it against Column B. Column C should carry with column B but shouldn't be considered when sorting. I hear VLOOKUP goes this, but I looked that over and was seriously confused.

Can someone provide detailed instructions on how to proceed?

Thank you!
0
Comment
Question by:Majo2469
  • 3
  • 3
7 Comments
 
LVL 13

Expert Comment

by:Shanan212
ID: 38751644
Can you post a sample set of data in a worksheet?
0
 
LVL 24

Expert Comment

by:Steve
ID: 38751763
VLOOKUP can be used, but it is more often better to use INDEX and MATCH functions

It will be best to demostrate on a sample you provide as it would be relevant to your needs.
0
 
LVL 3

Author Comment

by:Majo2469
ID: 38751810
Sure, I've attached an example.
What-I-Have.JPG
What-I-Need.JPG
0
3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

 
LVL 13

Expert Comment

by:Shanan212
ID: 38751878
Insert a column in between Column A and B
This will now become column B
On B2 enter
=IFERROR(VLOOKUP(A2,$C$2:$C$100,1,FALSE),"")

Drag it down. You will have your results.
0
 
LVL 3

Author Comment

by:Majo2469
ID: 38751899
Shanan212, That works, but I am wondering, is there any way I can keep the aligned so I can keep column D in line?
0
 
LVL 13

Accepted Solution

by:
Shanan212 earned 500 total points
ID: 38751926
You may. Copy column B and paste on top of it as values (hence removing formulas)
Then delete the column D (which houses previous data)
The new Column D would have the true/false formula.
0
 
LVL 3

Author Closing Comment

by:Majo2469
ID: 38751943
Thanks, It seems to work well!
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I'm trying, I really am. But I've seen so many wrong approaches involving date(time) boundaries I despair about my inability to explain it. I've seen quite a few recently that define a non-leap year as 364 days, or 366 days and the list goes on. …
Microsoft Office Picture Manager is not included in Office 2013. This comes as a shock to users upgrading from earlier versions of Office, such as 2007 and 2010, where Picture Manager was included as a standard application. This article explains how…
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now