Majo2469
asked on
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!
Can someone provide detailed instructions on how to proceed?
Thank you!
Can you post a sample set of data in a worksheet?
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.
It will be best to demostrate on a sample you provide as it would be relevant to your needs.
ASKER
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,FA LSE),"")
Drag it down. You will have your results.
This will now become column B
On B2 enter
=IFERROR(VLOOKUP(A2,$C$2:$
Drag it down. You will have your results.
ASKER
Shanan212, That works, but I am wondering, is there any way I can keep the aligned so I can keep column D in line?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks, It seems to work well!