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?
Bookmarks