Results 1 to 8 of 8

getting error using IF statement in Data Validation

Threaded View

  1. #1
    Registered User
    Join Date
    11-20-2013
    Location
    US
    MS-Off Ver
    Excel 2010
    Posts
    3

    getting error using IF statement in Data Validation

    Hi Experts-

    I'm creating a Shirt Order Form spreadsheet with dropdowns using Data Validation. I have 2 different types of shirts to choose from in F6, i would like the choices in H6 (shirt color) to change based the type of shirt chosen in F6. I'm attempting to do this using an IF statement in the Data Validation Source. I either get an error message or the drop down works for one and not the other.

    I've found several posts on this topic and have come across several suggested formulas, but none seem to be working. I'm sure its a minor thing i'm overlooking, so i've attached the sheet for review.

    I have data lists named in sheet2.

    Thanks!
    Attached Files Attached Files

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 With If statement
    By excobra in forum Excel General
    Replies: 6
    Last Post: 11-12-2013, 05:28 AM
  2. DATA Validation and IF statement
    By NCAA in forum Excel General
    Replies: 3
    Last Post: 03-29-2012, 04:01 AM
  3. Data validation in if statement
    By mahoo in forum Excel General
    Replies: 3
    Last Post: 02-15-2011, 04:06 PM
  4. Data validation IF statement
    By christopherp in forum Excel General
    Replies: 4
    Last Post: 11-12-2009, 11:27 AM
  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