+ Reply to Thread
Results 1 to 2 of 2

Dynamic conditional Drop down list First & Last Names

  1. #1
    Registered User
    Join Date
    08-11-2011
    Location
    Louisiana
    MS-Off Ver
    Excel 2016 & 365
    Posts
    39

    Dynamic conditional Drop down list First & Last Names

    Hello,

    I'm trying to figure out how to create a dynamic dropdown based on 2 criteria....matching First and Last names.

    For instance, my Last name dropdown gives me all of the last names. I choose "Smith". As we know, Smith is a very common name. I'd like to have a 2nd dropdown with only the first names of those with the last name Smith. I've tried searching and can't find a solution. Everything i find requires different lists to base your information on. In the example below, I only want to see John, Rosa, and Sam in a dropdown when I select "Smith" first. I should not see James as an option in the 2nd drop down list. I have one list of all people and want to extrapolate information based on their first and last names. I'll use vlookup for pulling further data.

    Smith John
    Smith Rosa
    Smith Sam
    Turner James

    I've got the Last name dropdown list covered. I just can't figure out how to do the first name one.

    Thanks in advance.

  2. #2
    Forum Expert PaulM100's Avatar
    Join Date
    10-09-2017
    Location
    UK
    MS-Off Ver
    Office 365
    Posts
    2,108

    Re: Dynamic conditional Drop down list First & Last Names

    These links contain straightforward explanations on dependant drop downs:
    http://www.contextures.com/xlDataVal13.html
    https://snpinfotech.wordpress.com/20...ists-in-excel/

+ 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. Create dynamic drop down list from dynamic data source
    By rz6657 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-18-2016, 05:22 PM
  2. [SOLVED] List in dynamic combobox which shows open workbook names and workshee names
    By igormigor in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-01-2016, 06:09 AM
  3. [SOLVED] Dynamic Drop down lists using numbers as header names
    By verno74 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-22-2015, 04:54 PM
  4. [SOLVED] Dynamic Drop Down of Specific Sheet Names
    By TrondG in forum Excel General
    Replies: 3
    Last Post: 10-16-2015, 09:19 AM
  5. Replies: 5
    Last Post: 03-26-2015, 01:40 PM
  6. [SOLVED] Create a Drop down that will list all names starting with initial letter of names.
    By blue leader in forum Excel - New Users/Basics
    Replies: 9
    Last Post: 01-16-2014, 03:58 PM
  7. [SOLVED] Dynamic Ranges as drop down lists based on another drop down list
    By Excel_Beginner_1 in forum Excel General
    Replies: 4
    Last Post: 05-15-2012, 03:31 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