+ Reply to Thread
Results 1 to 3 of 3

IF statement for data validation list

Hybrid View

  1. #1
    Registered User
    Join Date
    01-01-2011
    Location
    Sydney
    MS-Off Ver
    Excel 2003
    Posts
    3

    IF statement for data validation list

    Hi,

    Is it possible to put an IF statement in the data validation?
    I want the list to be determined by the value in a particular cell, so:
    Basically what I need it to do is look at cell A1, if cell A1 say "food" then i want a dropdown box in B1 with a list of my choosing
    If cell A2 says "Utility" then i want a dropdown box in B1 with a list of my choosing, which is to be different to the list available if A1 said food.

    Many thanks

    L

  2. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,327

    Re: IF statement for data validation list

    Hello & Welcome to the Board,

    I think this is what you want...

    Create Dependent Lists
    Create Dependent Lists 2
    HTH
    Regards, Jeff

  3. #3
    Registered User
    Join Date
    01-01-2011
    Location
    Sydney
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: IF statement for data validation list

    Thank you jeffreybrown
    EXACTLY what I needed, works perfectly.
    Thank you for the welcome, I can see myself getting very addicted to this forum!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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