Results 1 to 1 of 1

Problem with Dependent Dropdown Lists Being DYNAMIC

Threaded View

  1. #1
    Registered User
    Join Date
    06-26-2013
    Location
    USA
    MS-Off Ver
    Windows 7
    Posts
    45

    Problem with Dependent Dropdown Lists Being DYNAMIC

    Hello,

    I am having an interesting dilemma. Please see attached file.

    I have two sheets: a Customer Sheet and an Account Sheet. Each Customer could have multiple Accounts. A Customer can either be Active or Inactive. In addition, individual accounts belonging to the Customer can be Active or Inactive as well.

    On the "Accounts" Sheet I am using a Drop down List Data Validation to pick the Customer the Account belongs to and then a simple VLOOKUP function to see if the Customer is Active or Inactive. I need three things:

    1. If the CustomerStatus = "Active", then the Account Status column should have a choice to pick either Active or Inactive (hopefully using a drop down list??)
    2. If the CustomerStatus = "Inctive", then the Account Status column should automatically be "Inactive"
    3. If the CustomerStatus = "" (or blank), then the Account Status column should automatically say "Unknown"

    My problem specifically is when something changes in the Customer Sheet. For example, if a Customer Status changes, I want Account Status to reflect that change and clear its previous contents to fit one of the above scenarios.

    Is this clear?
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Dependent Dropdown Validation Lists
    By Root River Hardwoods in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-01-2014, 05:30 PM
  2. Multiple Rows and Columns in Dependent Dropdown Lists
    By JS1990 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-27-2013, 08:23 PM
  3. Creating Dependent Dropdown Lists in Excel 2011
    By Wilbers007 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 1
    Last Post: 05-18-2013, 06:05 AM
  4. Excel 2007 : Dependent DropDown lists
    By Harrison in forum Excel General
    Replies: 2
    Last Post: 07-12-2010, 06:32 PM
  5. Dependent dropdown lists
    By Axel in forum Excel General
    Replies: 1
    Last Post: 05-18-2006, 11:35 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1