Matching List Entries

[steev_jd]

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

 

[Duke Carey]

Sort one of the lists (Data>Sort)
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 D1100. In B1 put this formula and copy it down

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

 

[steev_jd]

Thanks.

I have a similar problem where i have two rows in each table. So i nee
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

 

[Dave Peterson]

You've got a reply at your later post.

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?