Excel CHOOSE Value Error
up vote
0
down vote
favorite
I am using MATCH
and CHOOSE
to populate a table. Basically, I want CHOOSE
to return values to an "11 row and 5 column" table from 52 different tables. Formula is below.
=+CHOOSE(MATCH($B$3,List!$M$5:$M$14),SAMS!$C$4:$G$14,SAMS!$C$17:$G$27,SAMS!$C$30:G$40,SAMS!C$43:G$53,SAMS!$C$56:$G$66,SAMS!$C$69:$G$79,SAMS!$C$82:$G$92,SAMS!$C$95:$G$105,SAMS!$C$108:$G$118,SAMS!$C$121:$G$131).
When MATCH
returns 1
, CHOOSE
works. But when it returns any other number, CHOOSE
does not work. Can you help? Thanks Ben
microsoft-excel
New contributor
add a comment |
up vote
0
down vote
favorite
I am using MATCH
and CHOOSE
to populate a table. Basically, I want CHOOSE
to return values to an "11 row and 5 column" table from 52 different tables. Formula is below.
=+CHOOSE(MATCH($B$3,List!$M$5:$M$14),SAMS!$C$4:$G$14,SAMS!$C$17:$G$27,SAMS!$C$30:G$40,SAMS!C$43:G$53,SAMS!$C$56:$G$66,SAMS!$C$69:$G$79,SAMS!$C$82:$G$92,SAMS!$C$95:$G$105,SAMS!$C$108:$G$118,SAMS!$C$121:$G$131).
When MATCH
returns 1
, CHOOSE
works. But when it returns any other number, CHOOSE
does not work. Can you help? Thanks Ben
microsoft-excel
New contributor
2
I hope the pending edit is to turn the formula into code{}
– spikey_richie
14 hours ago
1
(1) Do you realize that you are missing three$
signs? (2) You say that you want to “return values … from 52 different tables”. How is that supposed to happen when you have only 10 choices? If your actual formula lists 52 choices, (2a) thank you for editing it down to 10, but (2b) you should have said that you were presenting incomplete information, and (2c) it would have been nice if you had reduced it even more — say, enough that the formula could fit on one line. … (Cont’d)
– Scott
13 hours ago
1
(Cont’d) … (3) Are you sure thatMATCH
is returning a valid value? (3a) Have you used “Evaluate Formula”? (3b) Have you tried replacing theMATCH
call with a simple cell reference? (These are basic debugging procedures.) (3c) What debugging have you done? (4) Please don’t post a question saying that something “does not work”. What does it do? … … … … … … … … … … … Please do not respond in comments; edit your question to make it clearer and more complete.
– Scott
13 hours ago
add a comment |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
I am using MATCH
and CHOOSE
to populate a table. Basically, I want CHOOSE
to return values to an "11 row and 5 column" table from 52 different tables. Formula is below.
=+CHOOSE(MATCH($B$3,List!$M$5:$M$14),SAMS!$C$4:$G$14,SAMS!$C$17:$G$27,SAMS!$C$30:G$40,SAMS!C$43:G$53,SAMS!$C$56:$G$66,SAMS!$C$69:$G$79,SAMS!$C$82:$G$92,SAMS!$C$95:$G$105,SAMS!$C$108:$G$118,SAMS!$C$121:$G$131).
When MATCH
returns 1
, CHOOSE
works. But when it returns any other number, CHOOSE
does not work. Can you help? Thanks Ben
microsoft-excel
New contributor
I am using MATCH
and CHOOSE
to populate a table. Basically, I want CHOOSE
to return values to an "11 row and 5 column" table from 52 different tables. Formula is below.
=+CHOOSE(MATCH($B$3,List!$M$5:$M$14),SAMS!$C$4:$G$14,SAMS!$C$17:$G$27,SAMS!$C$30:G$40,SAMS!C$43:G$53,SAMS!$C$56:$G$66,SAMS!$C$69:$G$79,SAMS!$C$82:$G$92,SAMS!$C$95:$G$105,SAMS!$C$108:$G$118,SAMS!$C$121:$G$131).
When MATCH
returns 1
, CHOOSE
works. But when it returns any other number, CHOOSE
does not work. Can you help? Thanks Ben
microsoft-excel
microsoft-excel
New contributor
New contributor
edited 12 hours ago
cybernetic.nomad
1,027110
1,027110
New contributor
asked 14 hours ago
Bernard Oche
1
1
New contributor
New contributor
2
I hope the pending edit is to turn the formula into code{}
– spikey_richie
14 hours ago
1
(1) Do you realize that you are missing three$
signs? (2) You say that you want to “return values … from 52 different tables”. How is that supposed to happen when you have only 10 choices? If your actual formula lists 52 choices, (2a) thank you for editing it down to 10, but (2b) you should have said that you were presenting incomplete information, and (2c) it would have been nice if you had reduced it even more — say, enough that the formula could fit on one line. … (Cont’d)
– Scott
13 hours ago
1
(Cont’d) … (3) Are you sure thatMATCH
is returning a valid value? (3a) Have you used “Evaluate Formula”? (3b) Have you tried replacing theMATCH
call with a simple cell reference? (These are basic debugging procedures.) (3c) What debugging have you done? (4) Please don’t post a question saying that something “does not work”. What does it do? … … … … … … … … … … … Please do not respond in comments; edit your question to make it clearer and more complete.
– Scott
13 hours ago
add a comment |
2
I hope the pending edit is to turn the formula into code{}
– spikey_richie
14 hours ago
1
(1) Do you realize that you are missing three$
signs? (2) You say that you want to “return values … from 52 different tables”. How is that supposed to happen when you have only 10 choices? If your actual formula lists 52 choices, (2a) thank you for editing it down to 10, but (2b) you should have said that you were presenting incomplete information, and (2c) it would have been nice if you had reduced it even more — say, enough that the formula could fit on one line. … (Cont’d)
– Scott
13 hours ago
1
(Cont’d) … (3) Are you sure thatMATCH
is returning a valid value? (3a) Have you used “Evaluate Formula”? (3b) Have you tried replacing theMATCH
call with a simple cell reference? (These are basic debugging procedures.) (3c) What debugging have you done? (4) Please don’t post a question saying that something “does not work”. What does it do? … … … … … … … … … … … Please do not respond in comments; edit your question to make it clearer and more complete.
– Scott
13 hours ago
2
2
I hope the pending edit is to turn the formula into code{}
– spikey_richie
14 hours ago
I hope the pending edit is to turn the formula into code{}
– spikey_richie
14 hours ago
1
1
(1) Do you realize that you are missing three
$
signs? (2) You say that you want to “return values … from 52 different tables”. How is that supposed to happen when you have only 10 choices? If your actual formula lists 52 choices, (2a) thank you for editing it down to 10, but (2b) you should have said that you were presenting incomplete information, and (2c) it would have been nice if you had reduced it even more — say, enough that the formula could fit on one line. … (Cont’d)– Scott
13 hours ago
(1) Do you realize that you are missing three
$
signs? (2) You say that you want to “return values … from 52 different tables”. How is that supposed to happen when you have only 10 choices? If your actual formula lists 52 choices, (2a) thank you for editing it down to 10, but (2b) you should have said that you were presenting incomplete information, and (2c) it would have been nice if you had reduced it even more — say, enough that the formula could fit on one line. … (Cont’d)– Scott
13 hours ago
1
1
(Cont’d) … (3) Are you sure that
MATCH
is returning a valid value? (3a) Have you used “Evaluate Formula”? (3b) Have you tried replacing the MATCH
call with a simple cell reference? (These are basic debugging procedures.) (3c) What debugging have you done? (4) Please don’t post a question saying that something “does not work”. What does it do? … … … … … … … … … … … Please do not respond in comments; edit your question to make it clearer and more complete.– Scott
13 hours ago
(Cont’d) … (3) Are you sure that
MATCH
is returning a valid value? (3a) Have you used “Evaluate Formula”? (3b) Have you tried replacing the MATCH
call with a simple cell reference? (These are basic debugging procedures.) (3c) What debugging have you done? (4) Please don’t post a question saying that something “does not work”. What does it do? … … … … … … … … … … … Please do not respond in comments; edit your question to make it clearer and more complete.– Scott
13 hours ago
add a comment |
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
Bernard Oche is a new contributor. Be nice, and check out our Code of Conduct.
Bernard Oche is a new contributor. Be nice, and check out our Code of Conduct.
Bernard Oche is a new contributor. Be nice, and check out our Code of Conduct.
Bernard Oche is a new contributor. Be nice, and check out our Code of Conduct.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1376032%2fexcel-choose-value-error%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
2
I hope the pending edit is to turn the formula into code{}
– spikey_richie
14 hours ago
1
(1) Do you realize that you are missing three
$
signs? (2) You say that you want to “return values … from 52 different tables”. How is that supposed to happen when you have only 10 choices? If your actual formula lists 52 choices, (2a) thank you for editing it down to 10, but (2b) you should have said that you were presenting incomplete information, and (2c) it would have been nice if you had reduced it even more — say, enough that the formula could fit on one line. … (Cont’d)– Scott
13 hours ago
1
(Cont’d) … (3) Are you sure that
MATCH
is returning a valid value? (3a) Have you used “Evaluate Formula”? (3b) Have you tried replacing theMATCH
call with a simple cell reference? (These are basic debugging procedures.) (3c) What debugging have you done? (4) Please don’t post a question saying that something “does not work”. What does it do? … … … … … … … … … … … Please do not respond in comments; edit your question to make it clearer and more complete.– Scott
13 hours ago