+ Reply to Thread
Results 1 to 2 of 2

formula to make dropdown list change upon selections

  1. #1
    Registered User
    Join Date
    04-10-2024
    Location
    Melbourne, Australia
    MS-Off Ver
    MS365 2403
    Posts
    9

    formula to make dropdown list change upon selections

    hello,

    looking for a bit of assistance here so going to try my best to explain.

    the first selection option is model (C3) which has been data validated. from there, the second selection is the floor plan (C4) which has also been data validated. these will be manually selected. My issue is with suspension (C5). I have a helper formula in column D which changes the suspension option based off the model (C3), however I need a formula to change cells F8 and G7 to be the only options when their above model is selected and J20 as the specific floor plan. all other suspension options are available on the 20 other floor plans.

    Is this possible?
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    06-05-2017
    Location
    Brazil
    MS-Off Ver
    Microsoft 365 Version 2404
    Posts
    1,259

    Re: formula to make dropdown list change upon selections

    Hi.

    How are the suspension items and the floor plans related?

    For example, why should the cells E8 and F7 be the only options for the floor plan in cell J22?

+ 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. Reset all dropdown selections if tab change?
    By EduardStoo in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-08-2018, 05:20 AM
  2. Data Validation Multiple Selection - Keep Dropdown Box Open to Make Selections
    By PSSMargaret in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-31-2016, 12:32 PM
  3. Zooming Dropdown List Selections
    By enagli in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-03-2014, 05:37 PM
  4. [SOLVED] Conditional Formatting of List based on selections from Dropdown list
    By FoxyPinkChick in forum Excel General
    Replies: 4
    Last Post: 05-31-2013, 03:32 AM
  5. [SOLVED] Programming Dropdown Box to allow certain selections to change fonts
    By mykie in forum Word Formatting & General
    Replies: 6
    Last Post: 08-01-2012, 06:53 PM
  6. Dropdown list selections
    By Hustad in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 10-23-2009, 03:18 PM
  7. [SOLVED] How can I allow users to make multiple selections from a dropdown.
    By Liz in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-20-2005, 05:15 PM

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