Extracting data
 

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.

use vlookup. see in excel help


Al wrote in message
...
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.

Hi!

It would be helpful if you were more specific.

Biff

-----Original Message-----
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.
.

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" schrieb im Newsbeitrag
...
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.

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" wrote:

Hi!

It would be helpful if you were more specific.

Biff

-----Original Message-----
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.
.

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

-----Original Message-----
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" wrote:

Hi!

It would be helpful if you were more specific.

Biff

-----Original Message-----
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.
.


.

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

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



"Al" wrote in message
...
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.


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.788 / Virus Database: 533 - Release Date: 01/11/2004

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?

"Al" wrote:

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" wrote:

Hi!

It would be helpful if you were more specific.

Biff

-----Original Message-----
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.
.