software

I have a workbook that uses VLOOKUP on the Summary sheet to find values
associated with a Name and Week #. The worksheet I'm trying to capture the
data from looks like:
B C D E
Name | Week 0 | Week 1 | Week 2 | etc

Week 0 indicates the beginning and no real values are entered. My formula is:
=VLOOKUP(A6,Points!$B:$AB,$B$1 1,FALSE)

The problem is the result expected for Week 0 is quot;0quot; but instead it returns
the Name.

I tried MATCH as so:
=VLOOKUP(A6,Points!$B:$AB,MATCH(Summary!$B$1,Point s!C2:AB2,0),FALSE)

Same results received. Any number other than 0 in $B$1 returns the correct
result, but I want the initial sheet to show the corrct values.

Any help will be appreciated.

Hi!

Not sure I follow you........

If you enter 0 in B1 (or, if B1 is empty) then the formula is:

=VLOOKUP(A6,Points!$B:$AB,1,FALSE)

And returns the lookup_value (if found) from the first column of the
lookup_array.

Week 0 is in the second column of the table_array so you would need to enter
1 in B1.

gt; I tried MATCH as so:
gt; =VLOOKUP(A6,Points!$B:$AB,MATCH(Summary!$B$1,Point s!C2:AB2,0),FALSE)

If you use Match to find the column then in B1 you'd have to enter: Week n,
then change the range to:

=VLOOKUP(A6,Points!$B:$AB,MATCH(Summary!$B$1,Point s!B2:AB2,0),0)

Biff

quot;The Hawkquot; gt; wrote in message
...
gt;I have a workbook that uses VLOOKUP on the Summary sheet to find values
gt; associated with a Name and Week #. The worksheet I'm trying to capture
gt; the
gt; data from looks like:
gt; B C D E
gt; Name | Week 0 | Week 1 | Week 2 | etc
gt;
gt; Week 0 indicates the beginning and no real values are entered. My formula
gt; is:
gt; =VLOOKUP(A6,Points!$B:$AB,$B$1 1,FALSE)
gt;
gt; The problem is the result expected for Week 0 is quot;0quot; but instead it
gt; returns
gt; the Name.
gt;
gt; I tried MATCH as so:
gt; =VLOOKUP(A6,Points!$B:$AB,MATCH(Summary!$B$1,Point s!C2:AB2,0),FALSE)
gt;
gt; Same results received. Any number other than 0 in $B$1 returns the
gt; correct
gt; result, but I want the initial sheet to show the corrct values.
gt;
gt; Any help will be appreciated.
Thanks. It fixed that problem. I then tried to modify it for another
situation and it didn't work. Following is the situation:

gt; B C D E-H I J AB
gt; Name | Week -5 | Week -4 | ... | Week 1 | Week 2 | etc...

My modification was:

=VLOOKUP(A6,Reg_Scores!$I:$AB,MATCH(Summary!$B$1,R eg_Scores!$I$2:$AB$2,0),0)

Where is my thought process failing?

Thnaks...

quot;Biffquot; wrote:

gt; Hi!
gt;
gt; Not sure I follow you........
gt;
gt; If you enter 0 in B1 (or, if B1 is empty) then the formula is:
gt;
gt; =VLOOKUP(A6,Points!$B:$AB,1,FALSE)
gt;
gt; And returns the lookup_value (if found) from the first column of the
gt; lookup_array.
gt;
gt; Week 0 is in the second column of the table_array so you would need to enter
gt; 1 in B1.
gt;
gt; gt; I tried MATCH as so:
gt; gt; =VLOOKUP(A6,Points!$B:$AB,MATCH(Summary!$B$1,Point s!C2:AB2,0),FALSE)
gt;
gt; If you use Match to find the column then in B1 you'd have to enter: Week n,
gt; then change the range to:
gt;
gt; =VLOOKUP(A6,Points!$B:$AB,MATCH(Summary!$B$1,Point s!B2:AB2,0),0)
gt;
gt; Biff
gt;
gt; quot;The Hawkquot; gt; wrote in message
gt; ...
gt; gt;I have a workbook that uses VLOOKUP on the Summary sheet to find values
gt; gt; associated with a Name and Week #. The worksheet I'm trying to capture
gt; gt; the
gt; gt; data from looks like:
gt; gt; B C D E
gt; gt; Name | Week 0 | Week 1 | Week 2 | etc
gt; gt;
gt; gt; Week 0 indicates the beginning and no real values are entered. My formula
gt; gt; is:
gt; gt; =VLOOKUP(A6,Points!$B:$AB,$B$1 1,FALSE)
gt; gt;
gt; gt; The problem is the result expected for Week 0 is quot;0quot; but instead it
gt; gt; returns
gt; gt; the Name.
gt; gt;
gt; gt; I tried MATCH as so:
gt; gt; =VLOOKUP(A6,Points!$B:$AB,MATCH(Summary!$B$1,Point s!C2:AB2,0),FALSE)
gt; gt;
gt; gt; Same results received. Any number other than 0 in $B$1 returns the
gt; gt; correct
gt; gt; result, but I want the initial sheet to show the corrct values.
gt; gt;
gt; gt; Any help will be appreciated.
gt;
gt;
gt;

gt; B C D E-H I J
gt; AB
gt; Name | Week -5 | Week -4 | ... | Week 1 | Week 2 | etc...
gt;My modification was:
gt;=VLOOKUP(A6,Reg_Scores!$I:$AB,MATCH(Summary!$B$1, Reg_Scores!$I$2:$AB$2,0),0)
gt;Where is my thought process failing?

You've defined the lookup_array as $I:$AB so the formula looks for the
lookup_value (A6) in column I not column B.

Try this:

=VLOOKUP(A6,Reg_Scores!$B:$AB,MATCH(Summary!$B$1,R eg_Scores!$B$2:$AB$2,0),0)

Biff

quot;The Hawkquot; gt; wrote in message
...
gt; Thanks. It fixed that problem. I then tried to modify it for another
gt; situation and it didn't work. Following is the situation:
gt;
gt;gt; B C D E-H I J
gt;gt; AB
gt;gt; Name | Week -5 | Week -4 | ... | Week 1 | Week 2 | etc...
gt;
gt; My modification was:
gt;
gt; =VLOOKUP(A6,Reg_Scores!$I:$AB,MATCH(Summary!$B$1,R eg_Scores!$I$2:$AB$2,0),0)
gt;
gt; Where is my thought process failing?
gt;
gt; Thnaks...
gt;
gt; quot;Biffquot; wrote:
gt;
gt;gt; Hi!
gt;gt;
gt;gt; Not sure I follow you........
gt;gt;
gt;gt; If you enter 0 in B1 (or, if B1 is empty) then the formula is:
gt;gt;
gt;gt; =VLOOKUP(A6,Points!$B:$AB,1,FALSE)
gt;gt;
gt;gt; And returns the lookup_value (if found) from the first column of the
gt;gt; lookup_array.
gt;gt;
gt;gt; Week 0 is in the second column of the table_array so you would need to
gt;gt; enter
gt;gt; 1 in B1.
gt;gt;
gt;gt; gt; I tried MATCH as so:
gt;gt; gt; =VLOOKUP(A6,Points!$B:$AB,MATCH(Summary!$B$1,Point s!C2:AB2,0),FALSE)
gt;gt;
gt;gt; If you use Match to find the column then in B1 you'd have to enter: Week
gt;gt; n,
gt;gt; then change the range to:
gt;gt;
gt;gt; =VLOOKUP(A6,Points!$B:$AB,MATCH(Summary!$B$1,Point s!B2:AB2,0),0)
gt;gt;
gt;gt; Biff
gt;gt;
gt;gt; quot;The Hawkquot; gt; wrote in message
gt;gt; ...
gt;gt; gt;I have a workbook that uses VLOOKUP on the Summary sheet to find values
gt;gt; gt; associated with a Name and Week #. The worksheet I'm trying to capture
gt;gt; gt; the
gt;gt; gt; data from looks like:
gt;gt; gt; B C D E
gt;gt; gt; Name | Week 0 | Week 1 | Week 2 | etc
gt;gt; gt;
gt;gt; gt; Week 0 indicates the beginning and no real values are entered. My
gt;gt; gt; formula
gt;gt; gt; is:
gt;gt; gt; =VLOOKUP(A6,Points!$B:$AB,$B$1 1,FALSE)
gt;gt; gt;
gt;gt; gt; The problem is the result expected for Week 0 is quot;0quot; but instead it
gt;gt; gt; returns
gt;gt; gt; the Name.
gt;gt; gt;
gt;gt; gt; I tried MATCH as so:
gt;gt; gt; =VLOOKUP(A6,Points!$B:$AB,MATCH(Summary!$B$1,Point s!C2:AB2,0),FALSE)
gt;gt; gt;
gt;gt; gt; Same results received. Any number other than 0 in $B$1 returns the
gt;gt; gt; correct
gt;gt; gt; result, but I want the initial sheet to show the corrct values.
gt;gt; gt;
gt;gt; gt; Any help will be appreciated.
gt;gt;
gt;gt;
gt;gt;
Thank You!

quot;Biffquot; wrote:

gt; gt; B C D E-H I J
gt; gt; AB
gt; gt; Name | Week -5 | Week -4 | ... | Week 1 | Week 2 | etc...
gt; gt;My modification was:
gt; gt;=VLOOKUP(A6,Reg_Scores!$I:$AB,MATCH(Summary!$B$1, Reg_Scores!$I$2:$AB$2,0),0)
gt; gt;Where is my thought process failing?
gt;
gt; You've defined the lookup_array as $I:$AB so the formula looks for the
gt; lookup_value (A6) in column I not column B.
gt;
gt; Try this:
gt;
gt; =VLOOKUP(A6,Reg_Scores!$B:$AB,MATCH(Summary!$B$1,R eg_Scores!$B$2:$AB$2,0),0)
gt;
gt; Biff
gt;
gt; quot;The Hawkquot; gt; wrote in message
gt; ...
gt; gt; Thanks. It fixed that problem. I then tried to modify it for another
gt; gt; situation and it didn't work. Following is the situation:
gt; gt;
gt; gt;gt; B C D E-H I J
gt; gt;gt; AB
gt; gt;gt; Name | Week -5 | Week -4 | ... | Week 1 | Week 2 | etc...
gt; gt;
gt; gt; My modification was:
gt; gt;
gt; gt; =VLOOKUP(A6,Reg_Scores!$I:$AB,MATCH(Summary!$B$1,R eg_Scores!$I$2:$AB$2,0),0)
gt; gt;
gt; gt; Where is my thought process failing?
gt; gt;
gt; gt; Thnaks...
gt; gt;
gt; gt; quot;Biffquot; wrote:
gt; gt;
gt; gt;gt; Hi!
gt; gt;gt;
gt; gt;gt; Not sure I follow you........
gt; gt;gt;
gt; gt;gt; If you enter 0 in B1 (or, if B1 is empty) then the formula is:
gt; gt;gt;
gt; gt;gt; =VLOOKUP(A6,Points!$B:$AB,1,FALSE)
gt; gt;gt;
gt; gt;gt; And returns the lookup_value (if found) from the first column of the
gt; gt;gt; lookup_array.
gt; gt;gt;
gt; gt;gt; Week 0 is in the second column of the table_array so you would need to
gt; gt;gt; enter
gt; gt;gt; 1 in B1.
gt; gt;gt;
gt; gt;gt; gt; I tried MATCH as so:
gt; gt;gt; gt; =VLOOKUP(A6,Points!$B:$AB,MATCH(Summary!$B$1,Point s!C2:AB2,0),FALSE)
gt; gt;gt;
gt; gt;gt; If you use Match to find the column then in B1 you'd have to enter: Week
gt; gt;gt; n,
gt; gt;gt; then change the range to:
gt; gt;gt;
gt; gt;gt; =VLOOKUP(A6,Points!$B:$AB,MATCH(Summary!$B$1,Point s!B2:AB2,0),0)
gt; gt;gt;
gt; gt;gt; Biff
gt; gt;gt;
gt; gt;gt; quot;The Hawkquot; gt; wrote in message
gt; gt;gt; ...
gt; gt;gt; gt;I have a workbook that uses VLOOKUP on the Summary sheet to find values
gt; gt;gt; gt; associated with a Name and Week #. The worksheet I'm trying to capture
gt; gt;gt; gt; the
gt; gt;gt; gt; data from looks like:
gt; gt;gt; gt; B C D E
gt; gt;gt; gt; Name | Week 0 | Week 1 | Week 2 | etc
gt; gt;gt; gt;
gt; gt;gt; gt; Week 0 indicates the beginning and no real values are entered. My
gt; gt;gt; gt; formula
gt; gt;gt; gt; is:
gt; gt;gt; gt; =VLOOKUP(A6,Points!$B:$AB,$B$1 1,FALSE)
gt; gt;gt; gt;
gt; gt;gt; gt; The problem is the result expected for Week 0 is quot;0quot; but instead it
gt; gt;gt; gt; returns
gt; gt;gt; gt; the Name.
gt; gt;gt; gt;
gt; gt;gt; gt; I tried MATCH as so:
gt; gt;gt; gt; =VLOOKUP(A6,Points!$B:$AB,MATCH(Summary!$B$1,Point s!C2:AB2,0),FALSE)
gt; gt;gt; gt;
gt; gt;gt; gt; Same results received. Any number other than 0 in $B$1 returns the
gt; gt;gt; gt; correct
gt; gt;gt; gt; result, but I want the initial sheet to show the corrct values.
gt; gt;gt; gt;
gt; gt;gt; gt; Any help will be appreciated.
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt;
gt;
gt;

You're welcome!

Biff

quot;The Hawkquot; gt; wrote in message
...
gt; Thank You!
gt;
gt; quot;Biffquot; wrote:
gt;
gt;gt; gt; B C D E-H I J
gt;gt; gt; AB
gt;gt; gt; Name | Week -5 | Week -4 | ... | Week 1 | Week 2 | etc...
gt;gt; gt;My modification was:
gt;gt; gt;=VLOOKUP(A6,Reg_Scores!$I:$AB,MATCH(Summary!$B$1, Reg_Scores!$I$2:$AB$2,0),0)
gt;gt; gt;Where is my thought process failing?
gt;gt;
gt;gt; You've defined the lookup_array as $I:$AB so the formula looks for the
gt;gt; lookup_value (A6) in column I not column B.
gt;gt;
gt;gt; Try this:
gt;gt;
gt;gt; =VLOOKUP(A6,Reg_Scores!$B:$AB,MATCH(Summary!$B$1,R eg_Scores!$B$2:$AB$2,0),0)
gt;gt;
gt;gt; Biff
gt;gt;
gt;gt; quot;The Hawkquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; Thanks. It fixed that problem. I then tried to modify it for another
gt;gt; gt; situation and it didn't work. Following is the situation:
gt;gt; gt;
gt;gt; gt;gt; B C D E-H I J
gt;gt; gt;gt; AB
gt;gt; gt;gt; Name | Week -5 | Week -4 | ... | Week 1 | Week 2 | etc...
gt;gt; gt;
gt;gt; gt; My modification was:
gt;gt; gt;
gt;gt; gt; =VLOOKUP(A6,Reg_Scores!$I:$AB,MATCH(Summary!$B$1,R eg_Scores!$I$2:$AB$2,0),0)
gt;gt; gt;
gt;gt; gt; Where is my thought process failing?
gt;gt; gt;
gt;gt; gt; Thnaks...
gt;gt; gt;
gt;gt; gt; quot;Biffquot; wrote:
gt;gt; gt;
gt;gt; gt;gt; Hi!
gt;gt; gt;gt;
gt;gt; gt;gt; Not sure I follow you........
gt;gt; gt;gt;
gt;gt; gt;gt; If you enter 0 in B1 (or, if B1 is empty) then the formula is:
gt;gt; gt;gt;
gt;gt; gt;gt; =VLOOKUP(A6,Points!$B:$AB,1,FALSE)
gt;gt; gt;gt;
gt;gt; gt;gt; And returns the lookup_value (if found) from the first column of the
gt;gt; gt;gt; lookup_array.
gt;gt; gt;gt;
gt;gt; gt;gt; Week 0 is in the second column of the table_array so you would need to
gt;gt; gt;gt; enter
gt;gt; gt;gt; 1 in B1.
gt;gt; gt;gt;
gt;gt; gt;gt; gt; I tried MATCH as so:
gt;gt; gt;gt; gt; =VLOOKUP(A6,Points!$B:$AB,MATCH(Summary!$B$1,Point s!C2:AB2,0),FALSE)
gt;gt; gt;gt;
gt;gt; gt;gt; If you use Match to find the column then in B1 you'd have to enter:
gt;gt; gt;gt; Week
gt;gt; gt;gt; n,
gt;gt; gt;gt; then change the range to:
gt;gt; gt;gt;
gt;gt; gt;gt; =VLOOKUP(A6,Points!$B:$AB,MATCH(Summary!$B$1,Point s!B2:AB2,0),0)
gt;gt; gt;gt;
gt;gt; gt;gt; Biff
gt;gt; gt;gt;
gt;gt; gt;gt; quot;The Hawkquot; gt; wrote in message
gt;gt; gt;gt; ...
gt;gt; gt;gt; gt;I have a workbook that uses VLOOKUP on the Summary sheet to find
gt;gt; gt;gt; gt;values
gt;gt; gt;gt; gt; associated with a Name and Week #. The worksheet I'm trying to
gt;gt; gt;gt; gt; capture
gt;gt; gt;gt; gt; the
gt;gt; gt;gt; gt; data from looks like:
gt;gt; gt;gt; gt; B C D E
gt;gt; gt;gt; gt; Name | Week 0 | Week 1 | Week 2 | etc
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; Week 0 indicates the beginning and no real values are entered. My
gt;gt; gt;gt; gt; formula
gt;gt; gt;gt; gt; is:
gt;gt; gt;gt; gt; =VLOOKUP(A6,Points!$B:$AB,$B$1 1,FALSE)
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; The problem is the result expected for Week 0 is quot;0quot; but instead it
gt;gt; gt;gt; gt; returns
gt;gt; gt;gt; gt; the Name.
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; I tried MATCH as so:
gt;gt; gt;gt; gt; =VLOOKUP(A6,Points!$B:$AB,MATCH(Summary!$B$1,Point s!C2:AB2,0),FALSE)
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; Same results received. Any number other than 0 in $B$1 returns the
gt;gt; gt;gt; gt; correct
gt;gt; gt;gt; gt; result, but I want the initial sheet to show the corrct values.
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; Any help will be appreciated.
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt;
gt;gt;
gt;gt;