+ Reply to Thread
Results 1 to 2 of 2

If I choose this dropdown option in Excel, show me this new dropdown etc - Help please!

  1. #1
    Registered User
    Join Date
    09-03-2019
    Location
    UK
    MS-Off Ver
    MS Office 365 Business / v1907
    Posts
    1

    Question If I choose this dropdown option in Excel, show me this new dropdown etc - Help please!

    Hi all - new joiner and in desperate need of some help please! I'll try and explain this as well as I can :-)

    I want to create a series of logical option tables in excel that goes something like:

    IF I choose Option 1 in dropdown table 1
    THEN show me these options in dropdown table 2
    IF I choose Option 3 in dropdown table 2
    THEN show me these options in dropdown table 3
    IF I choose Option 25 in dropdown table 3
    THEN show me these options in dropdown table 4...

    And so on and so forth. So I'm left with a dynamic logic tree that only allows you to choose options based upon your previous selection.

    I've tried using several IF forumalas, VLOOKUP and a few others, and am getting nowhere :-(

    Any help hugely appreciated, thank you!!

  2. #2
    Forum Expert PaulM100's Avatar
    Join Date
    10-09-2017
    Location
    UK
    MS-Off Ver
    Office 365
    Posts
    2,108

    Re: If I choose this dropdown option in Excel, show me this new dropdown etc - Help please

    Here you can find how to do it: https://trumpexcel.com/dependent-dro...list-in-excel/
    Click the * to say thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Choose dropdown list than automatically show formula?
    By Mr.Castle in forum Excel General
    Replies: 6
    Last Post: 04-10-2019, 10:18 AM
  2. Replies: 13
    Last Post: 07-05-2018, 09:30 AM
  3. [SOLVED] Excel Dropdown Blank [User Can't Click Cells with Dropdown]
    By jamie.harris in forum Excel General
    Replies: 19
    Last Post: 06-21-2018, 04:27 PM
  4. Dropdown box suggested list option by typing the first letter of an option
    By jennis7242 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 08-19-2017, 10:39 PM
  5. Choose random tabs via dropdown
    By kimjaggi88 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-19-2016, 02:49 AM
  6. Replies: 5
    Last Post: 05-03-2016, 12:45 PM
  7. Replies: 2
    Last Post: 08-11-2011, 01:32 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