# Pulling information from lists

I have a user list that is that is 1000's of lines long and has a few columns.  I have another list that is hundreds of lines long.  They are in two separate files.  They have some common information between them.  I want to grab all of that information from the list that is 1000's of lines long with the hundreds of lines long list.  What is the best way to do this?  I need a quick fix for today and this may be a regular thing.

Thanks,

Awakenings
###### Who is Participating?

Commented:
Assuming the first list is on Sheet1 and the second on SHeet2...

=VLOOKUP(A2,Sheet1!A:B,2,FALSE)
0

Commented:
Hello awakenings,

I would dump the lists into Excel or Access, and evaluate them from there.  If the longest list
will fit in one worksheet (65536 rows in Excel 97-2003, or ~1 MM in Excel 2007) and if the
join is on one column, I'd go with Excel.  If not, then I'd go with Access.

Regards,

Patrick
0

Author Commented:
Patrick,

Of course I can put it into Excel, but how can I find the information I need from there?  How do I take the short list and pull the information from the long list?

Thanks,

Awakenings
0

Commented:
awakenings,

If it is a simple one-column join, then either VLOOKUP() or the combination of INDEX() and
MATCH() should do nicely.

Regards,

Patrick
0

Author Commented:
Patrick,

If you could provide a how-to, that would be great.  I created 3 columns as a test.  One column goes a-j.  The second column is 1-10 to represent the really long list.  The third column has a, c, d, g, and j.  Walk me through the steps of how I vlookup or inex and match.

Thanks,

Awakenings
0

Commented:
awakenings,

Can you post an example, with the expected output?

Regards,

Patrick
0

Author Commented:
C1    C2
a      1
b      2
c      3
d      4
e      5
f      6
g      7
h      8
I      9
j      10

The other file I can easily put into a column.  It specifically just has;
a
c
d
g
j

I need to have the output of;
a 1
c 3
d 4
g 7
j 10

Thanks,

Awakenings
0

Commented:
Forced accept.

Computer101