One way is via index/match

Check out Debra Dalgleish's coverage on INDEX/MATCH at her:
http://www.contextures.com/xlFunctions03.html
INDEX/MATCH

There's some sample workbooks available for d/l & study

p/s: Pl use a better, more relevant subject line in your next query
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:365 Subscribers:65
xdemechanik
---
"Christina" wrote:
I am trying to create a spreadsheet that has a lot of information. I would
like to be able to pull information from one sheet to another.

An example, i would like type in a name and have the rest of the sheet
populate with the information corresponding to that name.
ie. I would like to enter Microsoft and have about 10 fields automatically
calculate and generate the information into sheet one. I have all of the
information in Sheet 2

Please help. Thanks,