Trying to sort lists

[rich]

I have two lists of data which I am trying to match up with one
another to save me sifting through and sorting them manually. For
example the list 1 would look like this:

a 1
b 18
c 5
d 8
e 5
f 12
g 2

and list teo would look like this:

a 2
b 5
d 8
f 23
g 3

Now I want to match these two lists up so I get a list like this:

a 1 2
b 18 5
c 5
d 8 8
e 5
f 12 23
g 2 3

Is there any way of doing this as when list 1 consists of 100 entries
and list 2 consists of 78 it's very time consuming to match them up.

Thanks

 

[Pete McCosh]

Richard,

I'll assume your lists are on sheet 1 and sheet 2 with the
headings in column A and the values in column B. If this
is the case then, on sheet 1, cell C1, input the following
formula:

=vlookup(a1,'Sheet2'!$A$1:$B$78,2,false)

Then copy the formula and paste it as far down column C as
you need.

Cheers, Pete.

 

[rich]

Excel-ent P), Thanks Pete

Richard

Richard,

I'll assume your lists are on sheet 1 and sheet 2 with the
headings in column A and the values in column B. If this
is the case then, on sheet 1, cell C1, input the following
formula:

=vlookup(a1,'Sheet2'!$A$1:$B$78,2,false)

Then copy the formula and paste it as far down column C as
you need.

Cheers, Pete.