get data for a list from another list

[AGold]

Hello all, I am relatively new to Excel, and this problem likely has a simple answer, but I just can't find it. So here goes:
I have a master list that has about 10,000 rows, where column A is the "name" and columns b through p contains data (each row has a different name). I have another list that has about 5000 rows, where column A is the names and are a subset of the names in the master list. What I want to do is get the data from columns b through p from the master list for the 5000 rows in the subset list. I have zero experience with VBA, and very little experience with excel.
Any help is greatly appreciated.
Thanks so much,
AG

[swatsp0p]

Your task needs a VLOOKUP formula, where your 10,000 rows are the "table array". Make sure this table is sorted in ascending order by Column A and to make life easier, name this range something simple, e.g. Tble1.

On your second sheet, in cell B2 you will enter this formula:

=VLOOKUP($A2,Tble1,2,0)

Then copy this formula down and over your entire range of 5,000 rows from Col. B thru P.

Any values on your sub-list that are not on the Master will return #N/A.

HTH

[dcronje]

There are a number of ways of doing it the most effecient would be advanced filter (you can use help on how to use it) another method would be lookups for example

in b2 on the sheet with the subset list you can use the following formula (substitute "sheet1" with the name of the sheet with the master list:

=vlookup($a2,Sheet1!$A$2:$P$10001,2,False)

in c2 change the "2" to "3" and in d2 the "2" to a "4" etc. (eg:=vlookup($a2,Sheet1!$A$2:$P$10001,3,False))

once you have copied the formula to all the columns you can copy down the 5000 rows.

[AGold]

Hey Thanks for the reply!
I think that you are right in terms of what I need to do, but for some reason it won't work.
Do I have to put "sheet1" in there somewhere? My master list is sheet1 and my subset list is sheet2.
Thanks,
AG

[AGold]

Thanks dcronje,
You answered my question before I posted it!
I'll give that a try.
Thanks again!

[AGold]

thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you!!