copy the values of the cell based on multi choice drop down menu
I'm curious if what I want to do is possible. I have two sheets: 1. contains all the data for the admin assistants. 2. contains all the data for the faculty.
In sheet 1, each admin usually supports multiple faculty members (but it could be just one). So, I have a multi-choice drop-down with the faculty names in it.
In sheet 2, each faculty member only has one admin assigned to their.
Is it possible based on the drop-down selection in sheet 1 to auto-populate the corresponding columns (Admin Name, email, etc) in sheet 2, so they can only be updated once in sheet 1 (for example, if AA leaves and their faculty are assigned to a new AA, this can be updated in sheet2?
Help Article Resources
Check out the Formula Handbook template!