Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Returning a Value from Another Worksheet
I have two worksheets in one Excel 2007 file that I'm working with, in which
I want the second worksheet to return values of the first worksheet. Hope I can explain it clearly he The first sheet contains a list of data and numbers to caculate a points system. For example: Worksheet1 Name Column B Column C Points Data1 100 5 4 Data2 75 2 1 ... 2) In the second worksheet, I want to be able to input a specific value from Column A (i.e., I inputted "Data2" from Worksheet1) and, in the cell next to it, return its value from Column D from Worksheet1 (i.e. return the value of "4"): Worsheet2 Name Column B Data2 1 Is this possible and how can I get this to work? If you have any questions, please let me know. I know it may not be clear enough as it was hard to explain without showing it face-to-face. Thanks! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Returning a Value from Another Worksheet
....value from Column D from Worksheet1 (i.e. return the value of
"1")...versus "4". Sorry for the typo and confusions. Let's see if I can rewrite this clearer.... If data from Worksheet2 Column A = data from Worksheet1 Column A, then return it's correlating value in Worksheet1, Column D to Worksheet2, Column B. "TLH3934" wrote: I have two worksheets in one Excel 2007 file that I'm working with, in which I want the second worksheet to return values of the first worksheet. Hope I can explain it clearly he The first sheet contains a list of data and numbers to caculate a points system. For example: Worksheet1 Name Column B Column C Points Data1 100 5 4 Data2 75 2 1 ... 2) In the second worksheet, I want to be able to input a specific value from Column A (i.e., I inputted "Data2" from Worksheet1) and, in the cell next to it, return its value from Column D from Worksheet1 (i.e. return the value of "4"): Worsheet2 Name Column B Data2 1 Is this possible and how can I get this to work? If you have any questions, please let me know. I know it may not be clear enough as it was hard to explain without showing it face-to-face. Thanks! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Returning a Value from Another Worksheet
Did you try a vlookup?
Kristin "TLH3934" wrote: ...value from Column D from Worksheet1 (i.e. return the value of "1")...versus "4". Sorry for the typo and confusions. Let's see if I can rewrite this clearer.... If data from Worksheet2 Column A = data from Worksheet1 Column A, then return it's correlating value in Worksheet1, Column D to Worksheet2, Column B. "TLH3934" wrote: I have two worksheets in one Excel 2007 file that I'm working with, in which I want the second worksheet to return values of the first worksheet. Hope I can explain it clearly he The first sheet contains a list of data and numbers to caculate a points system. For example: Worksheet1 Name Column B Column C Points Data1 100 5 4 Data2 75 2 1 ... 2) In the second worksheet, I want to be able to input a specific value from Column A (i.e., I inputted "Data2" from Worksheet1) and, in the cell next to it, return its value from Column D from Worksheet1 (i.e. return the value of "4"): Worsheet2 Name Column B Data2 1 Is this possible and how can I get this to work? If you have any questions, please let me know. I know it may not be clear enough as it was hard to explain without showing it face-to-face. Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Returning data from MS Query into worksheet - 2007 | Excel Discussion (Misc queries) | |||
Sumif formula returning #VALUE when source worksheet is not open | Excel Discussion (Misc queries) | |||
Worksheet Formula Returning Sum of a Series | Excel Worksheet Functions | |||
Formula returning the worksheet name | Excel Discussion (Misc queries) | |||
Returning To Previous Worksheet - Help with sebastienm's code | Excel Discussion (Misc queries) |