Sort one of the lists (DataSort)
In the column adjacent to the sorted list use a VLOOKUP() formula

Let's say the sorted list is in A1:A100, and the other list you want to
match is in D1:D100. In B1 put this formula and copy it down

=if(isna(vlookup(a1,$d$1:$d$100,1,0)),"",vlookup(a 1,$d$1:$d$100,1,0))




"steev_jd" wrote:


Hi,

How / Is it possible to match entries in lists that are in a random
order and are different lengths

i.e.

col1 col2
1 1
2 2
5 7
6 6
8 9
3 3
4 4
7
9

To get
col 1 col 2
1 1
2 2
3 3
4 4
5
6 5
7 6
8
9 9

Being in order isnt particuarly important but matching up the values
is.

Thanks in advance.

Regards,
Steve


--
steev_jd
------------------------------------------------------------------------
steev_jd's Profile: http://www.excelforum.com/member.php...o&userid=33107
View this thread: http://www.excelforum.com/showthread...hreadid=530441