How do I get one cell to reference two other cells, so its selections change off those two?
I am making a write up sheet for my company for employees. They want me to make it as simple as possible to stop errors. I need help with the employee name selection. Basically, there is 3 positions (driver, vault, messenger) When I select a driver, I only want it to allow drivers to be selected and so on. Also, there are about 240 branches. So in the end I want to select a branch and then a position and under the Employee Name column, it will only have employees under that branch and position selected previously. Like, if I select the Detroit Branch and Driver position, only drivers under Detroit should be available.
P.S. I am already familiar with creating drop down boxes and have all my data needed, I just don't know the formula to enter under Employee Name to Reference Branch and Position at the same time. I do know how to do it for just Branch or position.
Any help would be appreciated. I attached a screen shot of the columns.
microsoft-excel worksheet-function
edited Dec 10 '18 at 22:28
Forward Ed
516213
asked Dec 10 '18 at 16:16
Christopher Rahn
1
add a comment |
I am making a write up sheet for my company for employees. They want me to make it as simple as possible to stop errors. I need help with the employee name selection. Basically, there is 3 positions (driver, vault, messenger) When I select a driver, I only want it to allow drivers to be selected and so on. Also, there are about 240 branches. So in the end I want to select a branch and then a position and under the Employee Name column, it will only have employees under that branch and position selected previously. Like, if I select the Detroit Branch and Driver position, only drivers under Detroit should be available.
P.S. I am already familiar with creating drop down boxes and have all my data needed, I just don't know the formula to enter under Employee Name to Reference Branch and Position at the same time. I do know how to do it for just Branch or position.
Any help would be appreciated. I attached a screen shot of the columns.
microsoft-excel worksheet-function
edited Dec 10 '18 at 22:28
Forward Ed
516213
asked Dec 10 '18 at 16:16
Christopher Rahn
1
2
not 100% sure what your question is, I think you need to look intoIndirect dynamic drop downs
– PeterH
Dec 10 '18 at 16:19
I will look into that. I already have my spreed sheet allowed to select the Branch, Position, and Employee name. After I select the Branch and Position, I only want employees from that branch and position to come up, so you cannot choose any other position or anyone from another branch. Like if i select Detroit and Driver, when I go to select employee it only gives me options of drivers from Detroit.
– Christopher Rahn
Dec 10 '18 at 16:25
this may help: contextures.com/xlDataVal02.html
– PeterH
Dec 10 '18 at 16:26
Sorry I did not mention, my spreadsheet already has Employee name dependent on the Branch selected. I want it to be dependent and Branch and Position. These articles only show how to make it dependent off 1 cell but not two cells at the same time. Unfortunately these do not work.
– Christopher Rahn
Dec 10 '18 at 16:36
This covers multiple dropdowns all cascading into each other
– cybernetic.nomad
Dec 10 '18 at 18:30
add a comment |
I am making a write up sheet for my company for employees. They want me to make it as simple as possible to stop errors. I need help with the employee name selection. Basically, there is 3 positions (driver, vault, messenger) When I select a driver, I only want it to allow drivers to be selected and so on. Also, there are about 240 branches. So in the end I want to select a branch and then a position and under the Employee Name column, it will only have employees under that branch and position selected previously. Like, if I select the Detroit Branch and Driver position, only drivers under Detroit should be available.
P.S. I am already familiar with creating drop down boxes and have all my data needed, I just don't know the formula to enter under Employee Name to Reference Branch and Position at the same time. I do know how to do it for just Branch or position.
Any help would be appreciated. I attached a screen shot of the columns.
microsoft-excel worksheet-function
edited Dec 10 '18 at 22:28
Forward Ed
516213
asked Dec 10 '18 at 16:16
Christopher Rahn
1
I am making a write up sheet for my company for employees. They want me to make it as simple as possible to stop errors. I need help with the employee name selection. Basically, there is 3 positions (driver, vault, messenger) When I select a driver, I only want it to allow drivers to be selected and so on. Also, there are about 240 branches. So in the end I want to select a branch and then a position and under the Employee Name column, it will only have employees under that branch and position selected previously. Like, if I select the Detroit Branch and Driver position, only drivers under Detroit should be available.
P.S. I am already familiar with creating drop down boxes and have all my data needed, I just don't know the formula to enter under Employee Name to Reference Branch and Position at the same time. I do know how to do it for just Branch or position.
Any help would be appreciated. I attached a screen shot of the columns.
microsoft-excel worksheet-function
microsoft-excel worksheet-function
edited Dec 10 '18 at 22:28
Forward Ed
516213
asked Dec 10 '18 at 16:16
Christopher Rahn
1
edited Dec 10 '18 at 22:28
Forward Ed
516213
asked Dec 10 '18 at 16:16
Christopher Rahn
1
edited Dec 10 '18 at 22:28
Forward Ed
516213
edited Dec 10 '18 at 22:28
Forward Ed
516213
edited Dec 10 '18 at 22:28
Forward Ed
516213
516213
asked Dec 10 '18 at 16:16
Christopher Rahn
1
asked Dec 10 '18 at 16:16
Christopher Rahn
1
asked Dec 10 '18 at 16:16
Christopher Rahn
1
1
2
not 100% sure what your question is, I think you need to look intoIndirect dynamic drop downs
– PeterH
Dec 10 '18 at 16:19
I will look into that. I already have my spreed sheet allowed to select the Branch, Position, and Employee name. After I select the Branch and Position, I only want employees from that branch and position to come up, so you cannot choose any other position or anyone from another branch. Like if i select Detroit and Driver, when I go to select employee it only gives me options of drivers from Detroit.
– Christopher Rahn
Dec 10 '18 at 16:25
this may help: contextures.com/xlDataVal02.html
– PeterH
Dec 10 '18 at 16:26
Sorry I did not mention, my spreadsheet already has Employee name dependent on the Branch selected. I want it to be dependent and Branch and Position. These articles only show how to make it dependent off 1 cell but not two cells at the same time. Unfortunately these do not work.
– Christopher Rahn
Dec 10 '18 at 16:36
This covers multiple dropdowns all cascading into each other
– cybernetic.nomad
Dec 10 '18 at 18:30
add a comment |
2
not 100% sure what your question is, I think you need to look intoIndirect dynamic drop downs
– PeterH
Dec 10 '18 at 16:19
I will look into that. I already have my spreed sheet allowed to select the Branch, Position, and Employee name. After I select the Branch and Position, I only want employees from that branch and position to come up, so you cannot choose any other position or anyone from another branch. Like if i select Detroit and Driver, when I go to select employee it only gives me options of drivers from Detroit.
– Christopher Rahn
Dec 10 '18 at 16:25
this may help: contextures.com/xlDataVal02.html
– PeterH
Dec 10 '18 at 16:26
Sorry I did not mention, my spreadsheet already has Employee name dependent on the Branch selected. I want it to be dependent and Branch and Position. These articles only show how to make it dependent off 1 cell but not two cells at the same time. Unfortunately these do not work.
– Christopher Rahn
Dec 10 '18 at 16:36
This covers multiple dropdowns all cascading into each other
– cybernetic.nomad
Dec 10 '18 at 18:30
2
2
not 100% sure what your question is, I think you need to look into
Indirect dynamic drop downs– PeterH
Dec 10 '18 at 16:19
not 100% sure what your question is, I think you need to look into
Indirect dynamic drop downs– PeterH
Dec 10 '18 at 16:19
I will look into that. I already have my spreed sheet allowed to select the Branch, Position, and Employee name. After I select the Branch and Position, I only want employees from that branch and position to come up, so you cannot choose any other position or anyone from another branch. Like if i select Detroit and Driver, when I go to select employee it only gives me options of drivers from Detroit.
– Christopher Rahn
Dec 10 '18 at 16:25
I will look into that. I already have my spreed sheet allowed to select the Branch, Position, and Employee name. After I select the Branch and Position, I only want employees from that branch and position to come up, so you cannot choose any other position or anyone from another branch. Like if i select Detroit and Driver, when I go to select employee it only gives me options of drivers from Detroit.
– Christopher Rahn
Dec 10 '18 at 16:25
this may help: contextures.com/xlDataVal02.html
– PeterH
Dec 10 '18 at 16:26
this may help: contextures.com/xlDataVal02.html
– PeterH
Dec 10 '18 at 16:26
Sorry I did not mention, my spreadsheet already has Employee name dependent on the Branch selected. I want it to be dependent and Branch and Position. These articles only show how to make it dependent off 1 cell but not two cells at the same time. Unfortunately these do not work.
– Christopher Rahn
Dec 10 '18 at 16:36
Sorry I did not mention, my spreadsheet already has Employee name dependent on the Branch selected. I want it to be dependent and Branch and Position. These articles only show how to make it dependent off 1 cell but not two cells at the same time. Unfortunately these do not work.
– Christopher Rahn
Dec 10 '18 at 16:36
This covers multiple dropdowns all cascading into each other
– cybernetic.nomad
Dec 10 '18 at 18:30
This covers multiple dropdowns all cascading into each other
– cybernetic.nomad
Dec 10 '18 at 18:30
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
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%2f1382365%2fhow-do-i-get-one-cell-to-reference-two-other-cells-so-its-selections-change-off%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Super User!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
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%2f1382365%2fhow-do-i-get-one-cell-to-reference-two-other-cells-so-its-selections-change-off%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
not 100% sure what your question is, I think you need to look into
Indirect dynamic drop downs– PeterH
Dec 10 '18 at 16:19
I will look into that. I already have my spreed sheet allowed to select the Branch, Position, and Employee name. After I select the Branch and Position, I only want employees from that branch and position to come up, so you cannot choose any other position or anyone from another branch. Like if i select Detroit and Driver, when I go to select employee it only gives me options of drivers from Detroit.
– Christopher Rahn
Dec 10 '18 at 16:25
this may help: contextures.com/xlDataVal02.html
– PeterH
Dec 10 '18 at 16:26
Sorry I did not mention, my spreadsheet already has Employee name dependent on the Branch selected. I want it to be dependent and Branch and Position. These articles only show how to make it dependent off 1 cell but not two cells at the same time. Unfortunately these do not work.
– Christopher Rahn
Dec 10 '18 at 16:36
This covers multiple dropdowns all cascading into each other
– cybernetic.nomad
Dec 10 '18 at 18:30