Alligning two columns

[NJ Office Man]

Hello,

I was wondering if there is a way or formula to allign two columns based on
equal fields. I have columns similar to below and want to align column 'b' to
its matching cases in column 'a'. I'm sure this is very simple but im kinda
new to excel, thanks for any help!

1 2
2 4
3 6
4 8
5 10
6
7
8
9
10

 

[Pete_UK]

Assuming your lists are in columns A and B, put this formula in C1:

=IF(ISNA(MATCH(A1,B:B,0)),"",A1)

Then copy it down for as many items as you have in column A.

Hope this helps.

Pete