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
--
Paul G
Software engineer.