Matching the values of 2 columns...problem

Hello,

I have to tell you that I am not even an Excel person. This is my first complex thing I ran into.

I have an Excel worksheet with 2 columns. A & B.

Column A has a list of over two thousand values. Column B has a list of about one thousand values. Column A is the longer one. Both columns are side by side.

Both columns have numbers. The same numbers appear in both columns. but some numbers do not appear and there are some totally different numbers.

Here is an actual screenshot of the columns:
http://i389.photobucket.com/albums/o...va/Problem.png

So, what I am trying to do is get at least one column to match with the other. If I can get column B to match with column A, it will be great.

I want the B column to match with the A column according to the same numbers. the numbers that don't match or is missing can be left blank...in another column.

I hope I made it clear. Please help me and if you have any questions, I will make it clear.

thanks a lot!

Hi,

If your data starts at A1, enter this into C1

=INDEX(B:B,MATCH(A1,B:B,0))

and copy it doen the whole length of data to produce a list of numbers that do match.