I have a list of 150 name with several rows of data associated with the name
.. I also have a 2nd list of 50 names. How can I extract the names 50 along
with the respective data. Is there a formula I can us. The list of 150
names changes every day but my 50 names stay the same?
--
hje

Here is one way. Use the advanced filter.

Here is how your data might look.
You need to have the column headers.

A B C D E F G H I J K
Name Age Height (blank) Name Age Height (blank) Name Age Height
J 22 165 (blank) P (blank) (blank) (blank)
P 23 170 (blank) S (blank) (blank) (blank)
S 28 184 (blank)
T 57 134 (blank)
P 35 188 (blank)

Copy the column headers so that you have them 3 times, side by side, with a
blank column in between.

Select all your data (in my example it is the first 3 columns.
Data Filter Advanced Filter
Copy to another location

List range is A1:C5
Criteria range is E1:G3
Copy to is I1:K1

So in your case you would have the whole list at the start,
then a blank column
then the headings and just the 50 names you are interested in getting out
then a blank column
then the headings where you are going to put your filtered information

HTH
--
Allllen


"Herman" wrote:

I have a list of 150 name with several rows of data associated with the name
. I also have a 2nd list of 50 names. How can I extract the names 50 along
with the respective data. Is there a formula I can us. The list of 150
names changes every day but my 50 names stay the same?
--
hje