Prev: Conditional Format Tracker by Date
Next: Hyperlinks not moving with cells when data is sorted
From: TLH3934 on 3 Feb 2010 16:19
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 here:

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!


From: TLH3934 on 3 Feb 2010 16:50
....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 here:
>
> 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!
>
>
From: Kristin on 4 Feb 2010 12:55
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 here:
> >
> > 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!
> >
> >
 | 
Pages: 1
Prev: Conditional Format Tracker by Date
Next: Hyperlinks not moving with cells when data is sorted