Results 1 to 5 of 5

how to create data validation drop-down list based on three conditions...

Threaded View

  1. 09-20-2016, 03:33 AM #1
    jiaron_1230
    jiaron_1230 is offline
    Registered User
    Join Date
    09-20-2016
    Location
    Malaysia
    MS-Off Ver
    MS Office 2016
    Posts
    43

    how to create data validation drop-down list based on three conditions...

    Here is a simple table that can explain the problem i hv....
    i would like to find value of X1+Y1+Z1, but in the table there's two values with same criteria...
    i would like to create drop-down list to each column A, B, C and D
    A to show X values
    B to show Y values
    C to show Z values
    and thn D show the values of combine 3 criteria...
    can someone help me?
    Attached Images Attached Images
    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. displaying list based on data selection in drop down of data validation
    By paradise2sr in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 12-16-2014, 12:51 AM
  2. Populate cell data based on data validation (drop down list)
    By ish_baho in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-05-2014, 11:47 PM
  3. [SOLVED] Drop Down Data Validation - Display a result based on multiple conditions
    By carlmf1987 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-25-2013, 01:50 PM
  4. Create data validation based on lookup to get a list
    By Rocky2013 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-16-2013, 11:31 AM
  5. [SOLVED] Data Validation: How to create a drop down list that excludes duplicate data
    By The_Snook in forum Excel General
    Replies: 5
    Last Post: 09-26-2013, 11:45 AM
  6. [SOLVED] Updating cells based on selection from drop down list data validation
    By jingles9 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-24-2013, 02:57 PM
  7. Create a drop down list using data validation that prevents duplicates being added
    By Greggywocky in forum Excel General
    Replies: 0
    Last Post: 09-08-2011, 02:22 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