Results 1 to 3 of 3

Drop down validation and formula

Threaded View

  1. 07-17-2019, 10:38 AM #1
    Fadzi
    Fadzi is offline
    Registered User
    Join Date
    02-04-2016
    Location
    Harare
    MS-Off Ver
    OFFICE 2010
    Posts
    8

    Drop down validation and formula

    Hello everyone. Please help
    I am creating a risk matrix in excel, where there are Primary Risks and secondary risks. The primary Risks are presented in a dop down. Now i would like the secondary risks in a drop down as well BUT, they should only correspond to the Primary Risk selected. For example Financial Risk is a primary risk category which has 4 secondary risks. Political Risks is a category which has 5 secondary risks. Now i would like that if one selects Financial then only a drop down of the 4 financial secondary risks appears. How do I accomplish this.
    I have attached the excel workbook
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] using a data validation drop down list AND an IF formula in the same cell
    By bite_tony in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-23-2021, 02:59 AM
  2. [SOLVED] Data Validation Drop Down using Index Match formula
    By onwankpa in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-25-2019, 03:01 AM
  3. [SOLVED] Formula Required for Data Validation Drop Down List
    By The_Snook in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-03-2019, 06:46 AM
  4. [SOLVED] Formula too long for drop down list data validation???
    By OAKLEY in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-02-2014, 06:15 PM
  5. Using either vlookup or IF formula with one Data Validation drop down
    By jagerhound in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-04-2013, 06:24 AM
  6. Can a VLOOKUP nest in an IF formula? Can I use both in a data validation drop down??
    By mltornroth in forum Excel General
    Replies: 4
    Last Post: 06-26-2012, 03:53 AM
  7. drop down validation with formula locked if deselected?
    By vause in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-26-2010, 02:26 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1