+ Reply to Thread
Results 1 to 6 of 6

Data validation and If statement

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    02-28-2013
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    272

    Re: Data validation and If statement

    Firstly Give a name to AO:AO as "High_End" & then in validation into list put following function:

    =INDIRECT(A2)
    Assuming your data in A2 & also use High_End instead of High End
    Please consider adding a * if I helped

  2. #2
    Registered User
    Join Date
    04-25-2013
    Location
    Wyoming
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: Data validation and If statement

    Correct me if I am wrong, but that still only defines the High End list. The trouble I am having is related to the ANY part in my equation. I don't have a list for Lower End, if it is Lower End I need to enter it manually.

+ 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. DATA Validation and IF statement
    By NCAA in forum Excel General
    Replies: 3
    Last Post: 03-29-2012, 04:01 AM
  2. Data validation in if statement
    By mahoo in forum Excel General
    Replies: 3
    Last Post: 02-15-2011, 04:06 PM
  3. Data validation IF statement
    By christopherp in forum Excel General
    Replies: 4
    Last Post: 11-12-2009, 11:27 AM
  4. How do I use a conditional (IF) statement in Data Validation?
    By Debra Dalgleish in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 09-06-2005, 02:05 PM
  5. using the if statement with data validation
    By GreenMonster in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-16-2005, 04:06 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