Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula for finding data from 2 worksheets
Hi; I am trying to find a formula that compares the data from one worksheet
to another. If the data matches I want data from another column on the second page. Example 1st Worksheet Department -- Donna |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula for finding data from 2 worksheets
Sorry I didn't get to complete:
Example: worksheet 1 worksheet 2 Name of deptments VP | Manager| Department | Employee I would like to be able to enter a formula that in worksheet 1 would put the manager or the employees of the department next to the department. -- Donna "Donna" wrote: Hi; I am trying to find a formula that compares the data from one worksheet to another. If the data matches I want data from another column on the second page. Example 1st Worksheet Department -- Donna |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula for finding data from 2 worksheets
Does anything match on the two worksheets? Do both worksheets have the
various different departments on them or do they both contain completly separate information with nothing that matches? "Donna" wrote: Sorry I didn't get to complete: Example: worksheet 1 worksheet 2 Name of deptments VP | Manager| Department | Employee I would like to be able to enter a formula that in worksheet 1 would put the manager or the employees of the department next to the department. -- Donna "Donna" wrote: Hi; I am trying to find a formula that compares the data from one worksheet to another. If the data matches I want data from another column on the second page. Example 1st Worksheet Department -- Donna |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula for finding data from 2 worksheets
They both have the data "department" and I want to find the manager or
employee for that department. -- Donna "Darrilyn" wrote: Does anything match on the two worksheets? Do both worksheets have the various different departments on them or do they both contain completly separate information with nothing that matches? "Donna" wrote: Sorry I didn't get to complete: Example: worksheet 1 worksheet 2 Name of deptments VP | Manager| Department | Employee I would like to be able to enter a formula that in worksheet 1 would put the manager or the employees of the department next to the department. -- Donna "Donna" wrote: Hi; I am trying to find a formula that compares the data from one worksheet to another. If the data matches I want data from another column on the second page. Example 1st Worksheet Department -- Donna |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula for finding data from 2 worksheets
Then it is easy. You will need to do a vlookup. Run a search for vlookup on
help and it should tell you everything you need to know. If you still need help reply to this and we'll figure it out. Thanks! Here is my example: Worksheet1 Department Employee HR Accounting "Donna" wrote: They both have the data "department" and I want to find the manager or employee for that department. -- Donna "Darrilyn" wrote: Does anything match on the two worksheets? Do both worksheets have the various different departments on them or do they both contain completly separate information with nothing that matches? "Donna" wrote: Sorry I didn't get to complete: Example: worksheet 1 worksheet 2 Name of deptments VP | Manager| Department | Employee I would like to be able to enter a formula that in worksheet 1 would put the manager or the employees of the department next to the department. -- Donna "Donna" wrote: Hi; I am trying to find a formula that compares the data from one worksheet to another. If the data matches I want data from another column on the second page. Example 1st Worksheet Department -- Donna |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula for finding data from 2 worksheets
I tried and for some reason I can't get it to work.
-- Donna "Darrilyn" wrote: Then it is easy. You will need to do a vlookup. Run a search for vlookup on help and it should tell you everything you need to know. If you still need help reply to this and we'll figure it out. Thanks! Here is my example: Worksheet1 Department Employee HR Accounting "Donna" wrote: They both have the data "department" and I want to find the manager or employee for that department. -- Donna "Darrilyn" wrote: Does anything match on the two worksheets? Do both worksheets have the various different departments on them or do they both contain completly separate information with nothing that matches? "Donna" wrote: Sorry I didn't get to complete: Example: worksheet 1 worksheet 2 Name of deptments VP | Manager| Department | Employee I would like to be able to enter a formula that in worksheet 1 would put the manager or the employees of the department next to the department. -- Donna "Donna" wrote: Hi; I am trying to find a formula that compares the data from one worksheet to another. If the data matches I want data from another column on the second page. Example 1st Worksheet Department -- Donna |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula for finding data from 2 worksheets
Let's say that it is in Worksheet1 that you need to put the manager name. In
the cell where you want to pull in the name you will type this: =vlookup(click on the first cell in Worksheet1 that has a department name because this is what excel is going to use as your matching criteria, then click over to worksheet2 and highlight from A1 to the end of the worksheet, on worksheet2 figure out what column the manager name is in and put that numeric value in here,false) so it should look something like this: =vlookup(A1,Worksheet2!A1:Z4,5,false) You can also use the formula builder under the insert option at the top and then function and find the vlookup and it will help walk you through it. Now you must make sure that the department column is before the manager or employee name or it will not work. "Donna" wrote: I tried and for some reason I can't get it to work. -- Donna "Darrilyn" wrote: Then it is easy. You will need to do a vlookup. Run a search for vlookup on help and it should tell you everything you need to know. If you still need help reply to this and we'll figure it out. Thanks! Here is my example: Worksheet1 Department Employee HR Accounting "Donna" wrote: They both have the data "department" and I want to find the manager or employee for that department. -- Donna "Darrilyn" wrote: Does anything match on the two worksheets? Do both worksheets have the various different departments on them or do they both contain completly separate information with nothing that matches? "Donna" wrote: Sorry I didn't get to complete: Example: worksheet 1 worksheet 2 Name of deptments VP | Manager| Department | Employee I would like to be able to enter a formula that in worksheet 1 would put the manager or the employees of the department next to the department. -- Donna "Donna" wrote: Hi; I am trying to find a formula that compares the data from one worksheet to another. If the data matches I want data from another column on the second page. Example 1st Worksheet Department -- Donna |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula for finding data from 2 worksheets
I did the vlookup like you said and it is not working. also what I am looking
for is if say column 5 data matches the data from worksheet one then I want to use the info from column 3 on worksheet 2. -- Donna "Darrilyn" wrote: Let's say that it is in Worksheet1 that you need to put the manager name. In the cell where you want to pull in the name you will type this: =vlookup(click on the first cell in Worksheet1 that has a department name because this is what excel is going to use as your matching criteria, then click over to worksheet2 and highlight from A1 to the end of the worksheet, on worksheet2 figure out what column the manager name is in and put that numeric value in here,false) so it should look something like this: =vlookup(A1,Worksheet2!A1:Z4,5,false) You can also use the formula builder under the insert option at the top and then function and find the vlookup and it will help walk you through it. Now you must make sure that the department column is before the manager or employee name or it will not work. "Donna" wrote: I tried and for some reason I can't get it to work. -- Donna "Darrilyn" wrote: Then it is easy. You will need to do a vlookup. Run a search for vlookup on help and it should tell you everything you need to know. If you still need help reply to this and we'll figure it out. Thanks! Here is my example: Worksheet1 Department Employee HR Accounting "Donna" wrote: They both have the data "department" and I want to find the manager or employee for that department. -- Donna "Darrilyn" wrote: Does anything match on the two worksheets? Do both worksheets have the various different departments on them or do they both contain completly separate information with nothing that matches? "Donna" wrote: Sorry I didn't get to complete: Example: worksheet 1 worksheet 2 Name of deptments VP | Manager| Department | Employee I would like to be able to enter a formula that in worksheet 1 would put the manager or the employees of the department next to the department. -- Donna "Donna" wrote: Hi; I am trying to find a formula that compares the data from one worksheet to another. If the data matches I want data from another column on the second page. Example 1st Worksheet Department -- Donna |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula for finding data from 2 worksheets
What is not working? If you want help you need to provide the details, post
your formula, describe what you excepted and what you got. -- Regards, Peo Sjoblom "Donna" wrote in message ... I did the vlookup like you said and it is not working. also what I am looking for is if say column 5 data matches the data from worksheet one then I want to use the info from column 3 on worksheet 2. -- Donna |
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula for finding data from 2 worksheets
The way a vlookup works is it takes whatever you put after the first open
paranthesis (i.e. =vlookup(A1) so it takes whatever is in A1, in your case the department, and goes over to your second sheet or workbook and finds that same value from the range that you set in the formula (Worksheet2!A1:Z25) and then whatever it finds in the column that you list (,5,) it pulls back over into the cell where the formula is written. You just have to make sure with a vlookup that your range that is set in the formula starts with the matching criteria, in this case your department, so if your department starts in column c when you click over to worksheet2 to set your range it will start at c1 and go to the end of the workbook and column a and b will be ignored, and that this matching criteria comes before the information that you want to pull over, in this case the manager or employee. I wish we could attach examples to this thing, would make it so much easier! "Donna" wrote: I did the vlookup like you said and it is not working. also what I am looking for is if say column 5 data matches the data from worksheet one then I want to use the info from column 3 on worksheet 2. -- Donna "Darrilyn" wrote: Let's say that it is in Worksheet1 that you need to put the manager name. In the cell where you want to pull in the name you will type this: =vlookup(click on the first cell in Worksheet1 that has a department name because this is what excel is going to use as your matching criteria, then click over to worksheet2 and highlight from A1 to the end of the worksheet, on worksheet2 figure out what column the manager name is in and put that numeric value in here,false) so it should look something like this: =vlookup(A1,Worksheet2!A1:Z4,5,false) You can also use the formula builder under the insert option at the top and then function and find the vlookup and it will help walk you through it. Now you must make sure that the department column is before the manager or employee name or it will not work. "Donna" wrote: I tried and for some reason I can't get it to work. -- Donna "Darrilyn" wrote: Then it is easy. You will need to do a vlookup. Run a search for vlookup on help and it should tell you everything you need to know. If you still need help reply to this and we'll figure it out. Thanks! Here is my example: Worksheet1 Department Employee HR Accounting "Donna" wrote: They both have the data "department" and I want to find the manager or employee for that department. -- Donna "Darrilyn" wrote: Does anything match on the two worksheets? Do both worksheets have the various different departments on them or do they both contain completly separate information with nothing that matches? "Donna" wrote: Sorry I didn't get to complete: Example: worksheet 1 worksheet 2 Name of deptments VP | Manager| Department | Employee I would like to be able to enter a formula that in worksheet 1 would put the manager or the employees of the department next to the department. -- Donna "Donna" wrote: Hi; I am trying to find a formula that compares the data from one worksheet to another. If the data matches I want data from another column on the second page. Example 1st Worksheet Department -- Donna |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula finding last cell in row containing data | Excel Worksheet Functions | |||
Formula for finding next cell with data? | Excel Discussion (Misc queries) | |||
Finding common Data in multiple worksheets | Excel Discussion (Misc queries) | |||
Finding DUplicate Data set in Worksheets | Excel Worksheet Functions | |||
Finding Data in multiple worksheets | Excel Discussion (Misc queries) |