Extracting data

A

Al

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.
 
F

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

Al said:
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
Click to expand...
appreciated.
 
A

Al

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.
 
B

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
 
U

utraceme

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?
 
Top