Help!

[Christina]

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,

 

[Max]

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

 

[Pete_UK]

Depending on how your data is laid out on Sheet2, you could do this
using VLOOKUP or an INDEX/MATCH combination. Can you give details of
how your data is arranged on Sheet2 (i.e. what the columns are used
for, and how many rows of data you have), together with how you want
it arranged on Sheet1?

Pete

 

[Eduardo]

Hi Christina,
let's say that the names are in column 1 in Sheet 1 & 2 so in column 2 of
sheet 1 enter
=VLOOKUP($A4,Sheet2!$A$:$J$,2,FALSE)
A to J are all the column from where you want to bring the information, then
copy the formula to the others columns and change 2 in the above formula with
3 to bring information from column 3 of Sheet 2 and so on

 

[Christina]

Eduardo, For some reason, that doesn't work. I have my information in sheet 2
in a vertical format. Is there some kind of visual basic thing i can run to
automatically generate the information when i type in a name?

thanks!

 

[Christina]

The data in sheet 2 is in rows. The first row is all titles and the second is
the information but it's all veritical. Ie.

John Smith...12/3/08...$12.65...etc.

I need to somehow pull this information from sheet 2 and put it on sheet 1
in an organized fashion. I would love if i could type in Sheet 1- John Smith
and the other information populate in the correct cell.

is that possible with a MATCH/VLOOKUP?

 

[Pete_UK]

Assume your data occupies columns A to J in Sheet2, with names in
column A, and that you enter a name in A1 of Sheet1. Put this formula
in B1 of Sheet1:

=VLOOKUP($A1,Sheet2!$A:$J,COLUMN(B1),0)

and copy across to J1.

Hope this helps.

Pete