ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Populate one column based on the dropdown choice of others (https://www.excelbanter.com/excel-discussion-misc-queries/239951-populate-one-column-based-dropdown-choice-others.html)

Nat August 17th 09 07:48 PM

Populate one column based on the dropdown choice of others
 
Here is the situation. My friend sent me a spreadsheet in 03 format. He has
3 columns which are affected : REASON, SOURCE and DEPARTMENT. The REASON
column has 11 choices. If the user chooses 3 of those choices ("new",
"refund", or "service" he would like the SOURCE column to have the following
choices: TA, Direct Guest, but if the user selects any of the other 8 choices
in REASON column, he would like the SOURCE column to have the following
choices: "TA", "Direct Guest", "Internal". If the user sees the 3 choices in
the SOURCE column and selects "Internal", then he would like for there to be
a drop down in the DEPARTMENT column.

He has named the lists as follows Srce1(2 choices) or Srce2 (3choices) and
Dept.

I saw an earlier post where someone did an IF(A2="New",Srce1) but i kept
getting errors when trying to add additional choices to "New"

Is there possibly a better way to accomplish this task?
Thanks a lot

Luke M August 17th 09 08:03 PM

Populate one column based on the dropdown choice of others
 
Check out this site for creating dependent lists:

http://www.contextures.com/xldataval02.html

It's got several examples which are pretty easy to follow, and as they say,
a picture is worth a thousand words!
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Nat" wrote:

Here is the situation. My friend sent me a spreadsheet in 03 format. He has
3 columns which are affected : REASON, SOURCE and DEPARTMENT. The REASON
column has 11 choices. If the user chooses 3 of those choices ("new",
"refund", or "service" he would like the SOURCE column to have the following
choices: TA, Direct Guest, but if the user selects any of the other 8 choices
in REASON column, he would like the SOURCE column to have the following
choices: "TA", "Direct Guest", "Internal". If the user sees the 3 choices in
the SOURCE column and selects "Internal", then he would like for there to be
a drop down in the DEPARTMENT column.

He has named the lists as follows Srce1(2 choices) or Srce2 (3choices) and
Dept.

I saw an earlier post where someone did an IF(A2="New",Srce1) but i kept
getting errors when trying to add additional choices to "New"

Is there possibly a better way to accomplish this task?
Thanks a lot


Nat August 17th 09 10:01 PM

Populate one column based on the dropdown choice of others
 
Thanks I can definitely use the dependent lists for the 1st part of this. In
the DEPARTMENT column, it would be nice if there is only a drop down choice
if a specific choice is selected. If I use the Indirect method, it still
lists a drop down arrow, it just will not allow you put something in that
column. It is functionally correct but a little misleading. Right now if
they choose "Internal" it gives them a drop down with choices. If they chose
something else, they still see the drop down arrow but just cannot enter
anything.

Thanks again. I am definitely on the correct path.

"Luke M" wrote:

Check out this site for creating dependent lists:

http://www.contextures.com/xldataval02.html

It's got several examples which are pretty easy to follow, and as they say,
a picture is worth a thousand words!
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Nat" wrote:

Here is the situation. My friend sent me a spreadsheet in 03 format. He has
3 columns which are affected : REASON, SOURCE and DEPARTMENT. The REASON
column has 11 choices. If the user chooses 3 of those choices ("new",
"refund", or "service" he would like the SOURCE column to have the following
choices: TA, Direct Guest, but if the user selects any of the other 8 choices
in REASON column, he would like the SOURCE column to have the following
choices: "TA", "Direct Guest", "Internal". If the user sees the 3 choices in
the SOURCE column and selects "Internal", then he would like for there to be
a drop down in the DEPARTMENT column.

He has named the lists as follows Srce1(2 choices) or Srce2 (3choices) and
Dept.

I saw an earlier post where someone did an IF(A2="New",Srce1) but i kept
getting errors when trying to add additional choices to "New"

Is there possibly a better way to accomplish this task?
Thanks a lot



All times are GMT +1. The time now is 03:43 AM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
ExcelBanter.com