Results 1 to 3 of 3

Fill cell with value after multiple dependant drop down list

Threaded View

  1. #1
    Forum Contributor
    Join Date
    03-28-2019
    Location
    Costa Rica
    MS-Off Ver
    2016
    Posts
    117

    Fill cell with value after multiple dependant drop down list

    Hello

    Some of the similar posts don't quite cover what I need hence thank you in advance for your assistance.

    I am working on a project where after multiple drop down selections the "resolution" outcome should be a procedure.
    I managed to create the dependent drop downs list however I am getting stuck to get the correct "resolution" outcome after the selections.

    For example.

    If the category "Promotions_Contests" is elected, multiple "issues" are available.
    Based on the Issue selected, multiple "reasons" are available
    When the "First_Time_Customer" options are elected (Yes or No) there will be a resolution.
    Here is where I get stuck. Based on the Yes/No selection there is a "fixed" resolution, how do I go about filling/displaying the resolution cell with the assigned resolution?

    Any ideas?
    I have attached a sample of the file.

    please note that based on elections, there may be two or even more possible solutions.


    Regards

    Mente
    Any help is much appreciated
    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] Create a dependant drop down list based on multiple entries with the same name
    By heidzhaydz in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 11-15-2019, 04:12 AM
  2. Replies: 1
    Last Post: 11-03-2018, 04:26 PM
  3. multiple drop down list/form and fill
    By liqt in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 06-21-2015, 04:12 PM
  4. Replies: 8
    Last Post: 11-16-2014, 06:34 PM
  5. Cell Contents dependant on Drop Down List
    By jamiemc in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-16-2014, 05:30 AM
  6. Multiple drop dependant drop downs in single cell
    By LittleJerry in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-07-2012, 02:21 PM
  7. Replies: 3
    Last Post: 07-06-2010, 05:30 AM

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