Results 1 to 4 of 4

dependant data validation

Threaded View

  1. #1
    Registered User
    Join Date
    03-22-2011
    Location
    Pittsburgh
    MS-Off Ver
    Excel 2007
    Posts
    2

    dependant data validation

    I have a data validation in cell B4. I need cell B21 to auto populate with a drop down list based on the value selected in the B4 drop down.

    For Example: If BREAKFAST FOOD is selected in cell B4, I need to the list in cells F37:F40 to appear in cell B21 as a drop down list.

    I know how to do this with a nested if statement for up to 7 lists but I need to do it for 17 lists.

    Got any ideas? Your help is greatly appreciated.
    Attached Files Attached Files

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