+ Reply to Thread
Results 1 to 8 of 8

getting error using IF statement in Data Validation

Hybrid 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

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,644

    Re: getting error using IF statement in Data Validation

    Seems to work fine for me.

    What should I do to reproduce the error?
    If posting code please use code tags, see here.

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

    Re: getting error using IF statement in Data Validation

    If you choose Under Armour in F6 there aren't any choices in H6. So Cornerstone works, Under Armour doesn't.

  4. #4
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: getting error using IF statement in Data Validation

    Take a close look at Under Armour in H1 on Sheet2 (where data validtion in F6 get's it's list from)
    It has a trailing space, so it actually equals "Under Armour "
    So the IF(F6="Under Armour" = False.

  5. #5
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: getting error using IF statement in Data Validation

    I didn't look at your file.

    See if the info at this link helps:

    http://contextures.com/xlDataVal02.html
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  6. #6
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,644

    Re: getting error using IF statement in Data Validation

    Oops, I was looking at columns C:E not F:H.

    Can you post the formula you are using for the data validation?

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

    Re: getting error using IF statement in Data Validation

    Thanks Jonmo1 its working now, that was the needle in the haystack!

  8. #8
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: getting error using IF statement in Data Validation

    You're welcome.

+ 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. [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