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

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

Thanks.

I have a similar problem where i have two rows in each table. So i need
to go from this

a¦1 a¦1
b¦2 c¦2
c¦2 d¦6
d¦7

to this
a¦1 a¦1
b¦2
c¦2 c¦2
d¦7 d¦6

Any suggestions?


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

You've got a reply at your later post.

steev_jd wrote:

Thanks.

I have a similar problem where i have two rows in each table. So i need
to go from this

a¦1 a¦1
b¦2 c¦2
c¦2 d¦6
d¦7

to this
a¦1 a¦1
b¦2
c¦2 c¦2
d¦7 d¦6

Any suggestions?

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

--

Dave Peterson