Need help with formula to automatically fill in Contact List from another column
I have the following columns and sheets and I just cannot seem to figure out how to do what I need.
- Sheet 1 (Main Sheet)
- Staff Listing (value is Text Full Name coming in from outside source)
- All Staff (Contact List selector (assigned to))
- Sheet 2 (reference Sheet)
- Technician Name - Contains full name
- Email Address - contains email address
I need to fill in the All Staff contact list automatically based on the Staff Listing value.
Any help would be very much appreciated.
Hey! You will be signed out in 60 seconds due to inactivity. Click here to continue using the site.