If I wanted to create a dropdown list of names, and a dropdown list of email addresses, and then a dropdown list for phone #'s, can I connect the dropdown lists so when I select a name from the name dropdown list, the corresponding email address and phone # auto populate into their respective cells?
No, at least not directly. Each pop-up menu is distinct, and not related to any other cell on the sheet.
There is a workaround/technique/hack(?) that gets close - basically by building a slew of pop-up menus, on separate cells, and using some creative formulas that hide the non-matching menus, but it can be complex to setup on large tables. Maybe worth a read, though:
Creating "nested" or "cascading" Pop-Up M… - Apple Community
Maybe it's not what you're looking for, but I find this system very useful.
You have your own unique database and you connect it to a table like table 2 where:
In A2 put a drop-down list with the names
In B2 put a VLOOKUP and MATCH
=VLOOKUP($A$2;DATABASE::A:C;MATCH($B$1;DATABASE::$1:$1;0))
If it doesn't work for you with the ; replace it with ,
In C2 you drag the formula of B2
Every time you change the name to A2 you have the respective emails and phones
VLOOKUP() (and its variants) work well if there's a single corresponding value (e.g. Find "Bob" and return his email address), but it doesn't work when there are multiple options. If Bob has multiple email addresses you can't get VLOOKUP() to find all of them and put them in a pop-up menu, for example, which was the OP's goal.
Thanks for these, I'll start working through them to see if I can make them work for me.
You're right.
In fact, I try to organize the database so that I have all the data of each person on the same line in several columns. This makes my research easier.
Multiple cells tied to a single dropdown
