I have a contact sheet with names going down the list and contact info in the cells to the right of each name.
On a separate signup sheet, I used data validation to create a drop down menu with the names from the contact sheet as options.
Next, I would like to set it up so that someone choosing one of these names automatically fills in the appropriate contact information in the neighboring cells.
Is this possible?
If I can do it but have to use a different method than the data validation, that's ok.