Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. . |
#4
|
|||
|
|||
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. |
#5
|
|||
|
|||
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. . |
#6
|
|||
|
|||
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. . . |
#7
|
|||
|
|||
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 |
#8
|
|||
|
|||
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. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with data not getting plotted | Excel Discussion (Misc queries) | |||
Help with data not getting plotted | Charts and Charting in Excel | |||
Charting data ranges that change | Charts and Charting in Excel | |||
Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) | |||
Data Table - Does it work with DDE links and stock tickers? | Excel Discussion (Misc queries) |