Results 1 to 6 of 6

How to use a condition on data validation

Threaded View

  1. #1
    Registered User
    Join Date
    10-25-2013
    Location
    United Kingdom
    MS-Off Ver
    Excel 2010
    Posts
    11

    How to use a condition on data validation

    Hi everyone,

    I have attached a file that has my problem in a simple form.

    I would like the drop down list in D15 to show only the house price values which are equal to or lower than that of the budget.

    The budget currently shows 50 (cell A2) so i would like the drop down list to show 20 and 50 (eventually i will link it to the names to show the names rather than the budget. )

    If i change the budget to 49 only the 20 should be in the list etc.

    hope this is clear

    thanks
    Attached Files Attached Files
    Last edited by murchy; 10-29-2013 at 10:32 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Data validation based on condition
    By Pavan.Sada.PS in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-17-2013, 09:56 AM
  2. Data validation with condition from another cell
    By hitarov in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-11-2013, 10:18 AM
  3. IF THEN condition with data validation
    By Dang-er in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-15-2013, 10:24 AM
  4. Data Validation with condition
    By Jaai001 in forum Excel General
    Replies: 6
    Last Post: 06-04-2011, 12:21 AM
  5. IF condition in Data Validation
    By e4excel in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 03-04-2011, 01:26 PM

Tags for this Thread

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