Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1895
  • Last Modified:

EXCEL 2010 - Match two columns

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
Majo2469
Asked:
Majo2469
  • 3
  • 3
1 Solution
 
Shanan212Commented:
Can you post a sample set of data in a worksheet?
0
 
SteveCommented:
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
 
Majo2469Author Commented:
Sure, I've attached an example.
What-I-Have.JPG
What-I-Need.JPG
0
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
Shanan212Commented:
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
 
Majo2469Author Commented:
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
 
Shanan212Commented:
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
 
Majo2469Author Commented:
Thanks, It seems to work well!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now