View Single Post
  #1   Report Post  
Old August 17th 09, 07:48 PM posted to microsoft.public.excel.misc
Nat Nat is offline
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2006
Posts: 47
Default 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