+ Reply to Thread
Results 1 to 4 of 4

IF function and drop down menus

  1. #1
    Registered User
    Join Date
    09-17-2009
    Location
    New Zealand
    MS-Off Ver
    Excel 2003
    Posts
    2

    IF function and drop down menus

    Is there an Excel guru that can help with this - its related to "drop down menus"


    I have 2 colombs of data.

    AT the bottom of the first, I have created a drop down menu using the "data validation" feature in excel.

    At the bottom of the second colomb, I have used an "IF" function that returns a result, which depends on what value is chosen from the drop down menu in colomb 1

    The problem I have is that I want the TRUE result from the IF function to be another drop down menu, being the data in colomb 2.


    How do you write an IF function where the TRUE result is a drop down menu??
    I tried to create a drop down menu of colomb2 elsewhere in the spread sheet, and used that cells location as the TRUE value, but this didn't work either...

    ANy suggestions??

  2. #2
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    re: IF function and drop down menus

    Hi,

    sounds like you need to explore dependent data validation. What you want to achieve is not done with an IF function, but by defining the list for the data validation based on the selection in the first drop down. Check out http://www.contextures.com/xlDataVal02.html for more details or google "dependent data validation"

    hth

  3. #3
    Registered User
    Join Date
    09-17-2009
    Location
    New Zealand
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: IF function and drop down menus

    You legend!!!!!


  4. #4
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: IF function and drop down menus

    You legend!!!!!
    "Tui" - Yeah, right!

    kiwi to kiwi, no sweat!

+ 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