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.
Bookmarks