Results 1 to 17 of 17

Dropdown list based on two criteria

Threaded View

  1. #1
    Registered User
    Join Date
    07-09-2011
    Location
    Melbourne
    MS-Off Ver
    Mac Excel 2011
    Posts
    6

    Dropdown list based on two criteria

    Hi,

    Thanks in advance for any thoughts or assistance you can provide. I am trying to create a drop down list that is dependent on two criteria. To depict the issue, I've created a mock-example about sports.

    On my 'data' sheet:
    Column 1: Name of sport
    Column 2: City
    Column 3: Name of sporting team

    On my 'form' sheet:
    Cell 1: Dropdown list to select name of sport
    Cell 2: Dropdown list to select city
    Cell 3: I want this cell to be a dropdown list of names of sporting teams, based on the conditions set by Cell 1 & 2.

    Example is attached.

    Thank you.
    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