Thanks Dave.

Gord

On Wed, 22 Aug 2007 16:33:53 -0500, Dave Peterson
wrote:

Typo alert!

In C1 enter =VLOOKUP(A1,Sheet2!$A$2:$D$20,2,FALSE)
should be:
In C1 enter =VLOOKUP(A1,Sheet2!$A$2:$D$20,4,FALSE)

(copy|paste is dangerous <vbg)

And to the original poster...

Debra Dalgleish has lots of notes on =vlookup():
http://www.contextures.com/xlFunctions02.html

Gord Dibben wrote:

You want programming or will worksheet functions do?

In sheet1 enter the names down column A in any order.

In B1 enter =VLOOKUP(A1,Sheet2!$A$2:$D$20,2,FALSE)

In C1 enter =VLOOKUP(A1,Sheet2!$A$2:$D$20,2,FALSE)

Copy these down as far as you have names in column A..........I used 20 rows.

Or use a Data Validation List dropdown in A2 with your list of names to pick
from.

Gord Dibben MS Excel MVP

On Wed, 22 Aug 2007 13:20:01 -0700, Paul wrote:

HI I on sheet 2 of an excel file I have
Name Age weight location
paul 10 150 calif
joe 8 90 az


on sheet 2 I have
paul
joe

need on sheet 2

paul 150 calif

joe 50 az

and would like to get the wieght and location for each and place them
in cells within the same row as the corresponding name.

and on sheet 1 I want to pull corresponding information.
On sheet one I will only have the name and on sheet 2
the names can be located in different locations so just a =sheet2,C2
will not work because the data location is not static. I do not want to
have to change the formula every time there is new data. Just wondering if
there is a way that excel can list
desired attributes on sheet on by just providing the name?
Thanks