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 |
+-------------------------------------------------------------------+
 
G

Guest

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
custom data validation on cells with data validation values 2
How to add values in one column based on values in another column 6
count unique values if 2 variables 6
Augmenting an integer in a column to reflect duplicates in another 23
If two criteria match then sum matching values in another column 5
counting values in a column 7
Finding multiple data values in a column 2

Top