Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Matching names and combining worksheets
I have one worksheet that contains Last Name, First Name of an entire
organization. I have another worksheet in the same file contains Last Name, First Name of a specific group within that organization. This worksheet also contains 2 other columns of information of that group (courses completed, courses attempted). I am trying to combine these worksheets so that the Last Name, First Name of the entire organization is shown and for those names that have a match with the 2nd worksheet, the courses completed and courses attempted data is shown. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Matching names and combining worksheets
Hi Irma,
if I didn't misunderstand as follow is what you need if you have the last name and First name in different columns like A and B in column C you can enter =A1&","&B1 you have to do this in both sheets I assume that the course information is in sheet 2 column D so in sheet 1 column D enter the formula as follow =Vlookup(a1,sheet2!$A$1:$D$1000,4,false) the above will bring the information related to the course If you have your Last and first name in one column just enter the last formula Hope this help "Irma A" wrote: I have one worksheet that contains Last Name, First Name of an entire organization. I have another worksheet in the same file contains Last Name, First Name of a specific group within that organization. This worksheet also contains 2 other columns of information of that group (courses completed, courses attempted). I am trying to combine these worksheets so that the Last Name, First Name of the entire organization is shown and for those names that have a match with the 2nd worksheet, the courses completed and courses attempted data is shown. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Matching names and combining worksheets
Thanks for the help, Eduardo.
I still can't manage to get the view I am looking for. Worksheet 1 has 2 columns: Last Name, First Name (a) and Team (b) Worksheet 2 has 4 columns: Last Name, First Name (a), Round (b), # Courses Completed (c) and # Courses in Progress (d). Worksheet 1 contains the names of ~1200 people; worksheet 2 is a list of 250 people (a subset of the 1200, but only those that were eligible to enroll in courses.) I would like to combine the reports to be a list of all employees (1200) and their Team name from Worksheet 1 and of those that match to my 2nd worksheet, the Round, # Courses Completed and # Courses in Progress. Thanks again for the help. "Eduardo" wrote: Hi Irma, if I didn't misunderstand as follow is what you need if you have the last name and First name in different columns like A and B in column C you can enter =A1&","&B1 you have to do this in both sheets I assume that the course information is in sheet 2 column D so in sheet 1 column D enter the formula as follow =Vlookup(a1,sheet2!$A$1:$D$1000,4,false) the above will bring the information related to the course If you have your Last and first name in one column just enter the last formula Hope this help "Irma A" wrote: I have one worksheet that contains Last Name, First Name of an entire organization. I have another worksheet in the same file contains Last Name, First Name of a specific group within that organization. This worksheet also contains 2 other columns of information of that group (courses completed, courses attempted). I am trying to combine these worksheets so that the Last Name, First Name of the entire organization is shown and for those names that have a match with the 2nd worksheet, the courses completed and courses attempted data is shown. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Matching names and combining worksheets
Hi Irma
So add to worksheet1 3 columns for Round (column c), # of courses completed (column D) and Courses in Progress (column E) then enter the formulas as follow assuming that your list start in row 2 Column C =vlookup(a2,sheet2!$a$2:$d$1500,2,false) ColumnD =vlookup(a2,sheet2!$a$2:$d$1500,3,false) Column E =vlookup(a2,sheet2!$a$2:$d$1500,4,false) "Irma A" wrote: Thanks for the help, Eduardo. I still can't manage to get the view I am looking for. Worksheet 1 has 2 columns: Last Name, First Name (a) and Team (b) Worksheet 2 has 4 columns: Last Name, First Name (a), Round (b), # Courses Completed (c) and # Courses in Progress (d). Worksheet 1 contains the names of ~1200 people; worksheet 2 is a list of 250 people (a subset of the 1200, but only those that were eligible to enroll in courses.) I would like to combine the reports to be a list of all employees (1200) and their Team name from Worksheet 1 and of those that match to my 2nd worksheet, the Round, # Courses Completed and # Courses in Progress. Thanks again for the help. "Eduardo" wrote: Hi Irma, if I didn't misunderstand as follow is what you need if you have the last name and First name in different columns like A and B in column C you can enter =A1&","&B1 you have to do this in both sheets I assume that the course information is in sheet 2 column D so in sheet 1 column D enter the formula as follow =Vlookup(a1,sheet2!$A$1:$D$1000,4,false) the above will bring the information related to the course If you have your Last and first name in one column just enter the last formula Hope this help "Irma A" wrote: I have one worksheet that contains Last Name, First Name of an entire organization. I have another worksheet in the same file contains Last Name, First Name of a specific group within that organization. This worksheet also contains 2 other columns of information of that group (courses completed, courses attempted). I am trying to combine these worksheets so that the Last Name, First Name of the entire organization is shown and for those names that have a match with the 2nd worksheet, the courses completed and courses attempted data is shown. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Matching names and combining worksheets
Eduardo...you're my hero!
That was it. Thanks so very much. "Eduardo" wrote: Hi Irma So add to worksheet1 3 columns for Round (column c), # of courses completed (column D) and Courses in Progress (column E) then enter the formulas as follow assuming that your list start in row 2 Column C =vlookup(a2,sheet2!$a$2:$d$1500,2,false) ColumnD =vlookup(a2,sheet2!$a$2:$d$1500,3,false) Column E =vlookup(a2,sheet2!$a$2:$d$1500,4,false) "Irma A" wrote: Thanks for the help, Eduardo. I still can't manage to get the view I am looking for. Worksheet 1 has 2 columns: Last Name, First Name (a) and Team (b) Worksheet 2 has 4 columns: Last Name, First Name (a), Round (b), # Courses Completed (c) and # Courses in Progress (d). Worksheet 1 contains the names of ~1200 people; worksheet 2 is a list of 250 people (a subset of the 1200, but only those that were eligible to enroll in courses.) I would like to combine the reports to be a list of all employees (1200) and their Team name from Worksheet 1 and of those that match to my 2nd worksheet, the Round, # Courses Completed and # Courses in Progress. Thanks again for the help. "Eduardo" wrote: Hi Irma, if I didn't misunderstand as follow is what you need if you have the last name and First name in different columns like A and B in column C you can enter =A1&","&B1 you have to do this in both sheets I assume that the course information is in sheet 2 column D so in sheet 1 column D enter the formula as follow =Vlookup(a1,sheet2!$A$1:$D$1000,4,false) the above will bring the information related to the course If you have your Last and first name in one column just enter the last formula Hope this help "Irma A" wrote: I have one worksheet that contains Last Name, First Name of an entire organization. I have another worksheet in the same file contains Last Name, First Name of a specific group within that organization. This worksheet also contains 2 other columns of information of that group (courses completed, courses attempted). I am trying to combine these worksheets so that the Last Name, First Name of the entire organization is shown and for those names that have a match with the 2nd worksheet, the courses completed and courses attempted data is shown. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Matching names and combining worksheets
Your welcome
"Irma A" wrote: Eduardo...you're my hero! That was it. Thanks so very much. "Eduardo" wrote: Hi Irma So add to worksheet1 3 columns for Round (column c), # of courses completed (column D) and Courses in Progress (column E) then enter the formulas as follow assuming that your list start in row 2 Column C =vlookup(a2,sheet2!$a$2:$d$1500,2,false) ColumnD =vlookup(a2,sheet2!$a$2:$d$1500,3,false) Column E =vlookup(a2,sheet2!$a$2:$d$1500,4,false) "Irma A" wrote: Thanks for the help, Eduardo. I still can't manage to get the view I am looking for. Worksheet 1 has 2 columns: Last Name, First Name (a) and Team (b) Worksheet 2 has 4 columns: Last Name, First Name (a), Round (b), # Courses Completed (c) and # Courses in Progress (d). Worksheet 1 contains the names of ~1200 people; worksheet 2 is a list of 250 people (a subset of the 1200, but only those that were eligible to enroll in courses.) I would like to combine the reports to be a list of all employees (1200) and their Team name from Worksheet 1 and of those that match to my 2nd worksheet, the Round, # Courses Completed and # Courses in Progress. Thanks again for the help. "Eduardo" wrote: Hi Irma, if I didn't misunderstand as follow is what you need if you have the last name and First name in different columns like A and B in column C you can enter =A1&","&B1 you have to do this in both sheets I assume that the course information is in sheet 2 column D so in sheet 1 column D enter the formula as follow =Vlookup(a1,sheet2!$A$1:$D$1000,4,false) the above will bring the information related to the course If you have your Last and first name in one column just enter the last formula Hope this help "Irma A" wrote: I have one worksheet that contains Last Name, First Name of an entire organization. I have another worksheet in the same file contains Last Name, First Name of a specific group within that organization. This worksheet also contains 2 other columns of information of that group (courses completed, courses attempted). I am trying to combine these worksheets so that the Last Name, First Name of the entire organization is shown and for those names that have a match with the 2nd worksheet, the courses completed and courses attempted data is shown. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combining first and last names into one column | Excel Worksheet Functions | |||
Matching names | Excel Discussion (Misc queries) | |||
Sorting and matching rows of names with Socials with master list and eliminating the extra names | Excel Worksheet Functions | |||
Combining non-matching date series in one chart | Charts and Charting in Excel | |||
Combining first and last names | Setting up and Configuration of Excel |