This seems like a simple problem but I haven't been able to find any information that helps. I've got a list of names in a table split by first and last name:
e.g.
LastName, FirstName, a whack of other columns of stats.
Staal, Eric, stats columns
Staal, Jordan, stats columns
Staal, Marc, stats columns
Sedin, Daniel, stats columns
Sedin, Henrik, stats columns
Tanguay, Alex, stats columns
Thornton, Joe, stats columns
etc.
I'm trying to set up (in a separate table) data validation based on the first table. There is also a last name and first name column. Setting up data validation for the first column is dead simple. Just set the list to the LastName column of my original table.
The second column data validation is not so easy however. I'd like it to show a drop down list which would only allow entry of first names that exist for the last name chosen. e.g. if sombody chooses "Sedin" for the last name, a drop down entry list for the first name would consist of "Henrik" and "Daniel".
All the look-up functions seem to only return single values, as opposed to lists in the form of e.g. {"Henrik","Daniel"}. I've seen example using INDIRECT() but this would be impractical for this application. There are potentially hundreds of last names, many of which would share the same first name. Creating a pre-set named list of first names for each last name (outside of the original name list) would negate the worth (to me) of having a data validation entry.
Is there some sort of SQL type function that I could use (i.e. SELECT FirstName FROM [Table] WHERE LastName="Sedin")?
Is there some way that this can be accomplished? Thanks for any help.
Bookmarks