How to match values in one column to values in another?

T

trib

I have the following question:

I have about 2000 records in Column 1 (a code consisting of letters and
numbers). In Column 2 I have about 1500 records. All of the records in
Column 2 are contained in Column 1. However, since about 500 are
missing I cannot sort the equal values next to one another -

How to make it so that Excel matches the values in Column 2 next to the
same values in Column 1?

I have attached a word file in order to show a sample of what I need.


+-------------------------------------------------------------------+
|Filename: Question.doc |
|Download: http://www.excelforum.com/attachment.php?postid=5077 |
+-------------------------------------------------------------------+
 
M

Max

Assuming Series 1 starts in A2 down, Series 2 starts in B2 down

Put in C2:
=IF(ISNUMBER(MATCH(A2,B:B,0)),A2,"")
Copy C2 down to the last row of data in col A

Col C will return the required results
If desired, just cut out col C and paste special as values to overwrite col B
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sum Values from different column 1
Automatically sending multiple parts of text from one word doc to another - is possible. 0
List all tables, including document structure 0
Get sum of values in a cell based on unique values in another cell 3
How to Import Formatted text as new Slides in PowerPoint 0
Unique Records in Column 3
how to copy and paste value from one sheet to another 4
Select minimum with duplicate values to return column headings 3

Top