+ Reply to Thread
Results 1 to 3 of 3

Formula to present specific value OR a drop down box depending on value in other cell

  1. #1
    Registered User
    Join Date
    12-11-2013
    Location
    Maryland
    MS-Off Ver
    Excel 2007
    Posts
    5

    Formula to present specific value OR a drop down box depending on value in other cell

    I am trying to come up with a formula in B2 that will either return a set value of text ("COMPLETE") or offer a drop down box with other text options depending on the value selected from a drop down box in A2.

    A2 has a named range called "Results" that has several possible coded values for results (LVM, REF, REN, NA, EOO, RC). If the user selects REF, REN, or EOO on the A2 drop down box, then B2 needs to be marked "COMPLETE". If they select any other value code, then B2 needs to display the same drop down options as A2.

    Thanks in advance for any assistance!

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Formula to present specific value OR a drop down box depending on value in other cell

    Hi,

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    12-11-2013
    Location
    Maryland
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Formula to present specific value OR a drop down box depending on value in other cell

    If I'm not mistaken wouldn't that just return the same VALUE that is selected from the drop down A2 if it is not a "COMPLETE", as opposed to making the whole drop down available again in B2? I need the whole drop down to be available in B2 if any code other than REF, REN, or EOO is selected in A2. I hope that made more sense.

+ 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. Replies: 6
    Last Post: 04-05-2014, 07:17 PM
  2. Formula to check if specific name is present in 3 different lists.
    By sakmsb in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 04-03-2014, 05:01 PM
  3. [SOLVED] formula to tell me when someone is present on work, present late and early departure.
    By Shellybelly in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-03-2013, 01:38 AM
  4. [SOLVED] Part 2 - a formula that says yes or no depending upon a range of drop down boxes
    By mfairhurst1 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-14-2013, 09:36 AM
  5. Formula to calculate totals depending on Drop Down Menu
    By Hadda in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-17-2013, 09:41 PM
  6. Return specific numbers from a chart depending on drop down box selection
    By JasonTV in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-12-2011, 08:22 AM
  7. Drop Down Lists - Depending on other cell values
    By LaDonna1024 in forum Excel General
    Replies: 6
    Last Post: 10-23-2008, 03:20 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