See my attached spreadsheet for an idea of what I'm trying to build
I would like to have a drop down in cell A2, that displays several names. When a name is selected, it will automatically populate the cells in B2 & C2 with a home and cell phone numbers.
In E2-G6, I've given examples of the phone numbers to be displayed. Note that not every person has both phone numbers.
Is this something easy to set up?
Bookmarks