Trying to sort lists

  • Thread starter Thread starter rich
  • Start date Start date
R

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
 
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.
 
Excel-ent (:P), Thanks Pete

Richard

Pete McCosh said:
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.
Click to expand...
 
Back
Top