Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If cell equals a name then get data from column
I need to pull data from monthly spreadsheets that is a list of names and
results. The names are not always in the same order. I need to collate the results by line manager. The list of names is not divided into line manager teams. I have a sheet already that lists team member by line manager. I now need to populate the data. So I really need is if cell on data sheet = "persons name" then show me the data in column u for that person. Any ideas? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If cell equals a name then get data from column
Is hard to tell where you want to put the data?
Next to the name listed next to the line Manager? If so...and the data is numerical and needs to be summed??? =SUMIF(A:A,A2,B:B) where A:A = "Persons Name" Column on Monthly Spreadsheet. Where A2 = Persons Name. From Line Manager/ Employeee list. Where B:B = Data for collection. It's all about how you ask the question, so i'm not sure if this helps or not? Bam. "JDB" wrote: I need to pull data from monthly spreadsheets that is a list of names and results. The names are not always in the same order. I need to collate the results by line manager. The list of names is not divided into line manager teams. I have a sheet already that lists team member by line manager. I now need to populate the data. So I really need is if cell on data sheet = "persons name" then show me the data in column u for that person. Any ideas? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If cell equals a name then get data from column
Check out the VLOOKUP function examples in help.
=VLOOKUP(person's name,lookup_table,column_number,FALSE) "person's name" can be a cell reference. Gord Dibben MS Excel MVP On Wed, 24 Sep 2008 05:03:01 -0700, JDB wrote: I need to pull data from monthly spreadsheets that is a list of names and results. The names are not always in the same order. I need to collate the results by line manager. The list of names is not divided into line manager teams. I have a sheet already that lists team member by line manager. I now need to populate the data. So I really need is if cell on data sheet = "persons name" then show me the data in column u for that person. Any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CELL EQUALS LAST NONBLANK CELL IN A COLUMN | Excel Worksheet Functions | |||
countif column d equals x and column a noblank | Excel Worksheet Functions | |||
How to get less than dates if Data in another column equals data | Excel Worksheet Functions | |||
If a cell equals _, at the next row that equals _, return value fr | Excel Worksheet Functions | |||
If cell is left blank, or equals zero, then cell equals a different cell | Excel Discussion (Misc queries) |