Extracting data

[Guest]

in tab A I have my Raw data. One of the columns is of names. what I want to
do is in Tab B, where I have my analysis and my names already listed, and I
want to copy the data from tab A to Tab B based on that name value. I think
it is a lookup function but I am not sure. Any help is of course appreciated.

 

[R.VENKATARAMAN]

use vlookup. see in excel help

in tab A I have my Raw data. One of the columns is of names. what I want to
do is in Tab B, where I have my analysis and my names already listed, and I
want to copy the data from tab A to Tab B based on that name value. I think
it is a lookup function but I am not sure. Any help is of course

appreciated.

 

[Biff]

Hi!

It would be helpful if you were more specific.

Biff

 

[Frank Kabel]

Hi
only a general idea:
have a look at VLOOKUP (http://www.contextures.com/xlFunctions02.html)
Also you may consider using a pivot table. See:
http://www.cpearson.com/excel/pivots.htm
http://peltiertech.com/Excel/Pivots/pivotstart.htm
http://www.contextures.com/xlPivot02.html
http://www.ozgrid.com/Excel/excel-pivot-tables.htm

--
Regards
Frank Kabel
Frankfurt, Germany

in tab A I have my Raw data. One of the columns is of names. what I want to
do is in Tab B, where I have my analysis and my names already listed, and I
want to copy the data from tab A to Tab B based on that name value. I think
it is a lookup function but I am not sure. Any help is of course

appreciated.

 

[Guest]

Tab A has column A as "last name, first name" with a performance breakdown
of about 20 variables listed going off to the right. I need to extract 4-5
variables out of that information based on the name column. To other tabs
taht are being set up based on name. I think it has to do with a lookup
function but I'm not sure exactly how to set it up.

 

[Biff]

Hi!

Do the columns that hold the 20 variables have headers?

I'll assume that A2:A8 are the list of names.
B1:U1 are the headers for the 20 performance variables.

Two ways to do this:

=INDEX(B2:U8,MATCH("BOB",A2:A8,0),MATCH
("whatever",B1:U1,0))

=VLOOKUP("BOB",A1:U8,MATCH("whatever",A1:U1,0),0)

You can make these more versatile by using cell references
for the lookup and match values. In both cases, "whatever"
refers to the performance variable.

Biff

 

[Ken Wright]

Pivot tables were made to make this kind of stuff real easy.

 

[Guest]

What about if you have to do the same thing but the same name is repeated and
you need all the instances where it is called out with the associated 4-5
variables?