Solved

EXCEL 2010 - Match two columns

Posted on 2013-01-07
7
1,840 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
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
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

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

PaperPort has a feature called the "Send To Bar". It provides a convenient, drag-and-drop interface for using other installed software, such as Microsoft Office. However, this article shows that the latest Office 2016 apps (installed with an Office …
In this article we discuss how to recover the missing Outlook 2011 for Mac data like Emails and Contacts manually.
The viewer will learn how to  create a slide that will launch other presentations in Microsoft PowerPoint. In the finished slide, each item launches a new PowerPoint presentation and when each is finished it automatically comes back to this slide: …
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

747 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

10 Experts available now in Live!

Get 1:1 Help Now