[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1893
  • 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
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
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

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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