VLookUp -- Maybe?
I have a sheet that lists all our staff and all the columns across list contact information (phone, email, desk info, etc).
I want to create a sheet that assigns staff to a clinical area by dropping down the staff person's name and have all their contact information to share (that is pulled from a separate sheet).
Is there a way I can dropdown the list, click a name, and it pulls all the contact information from another sheet? I have read the vlookup articles but I can get it right in my head.
I plan on "assigning" staff day by day to different clinical areas, but create some reports and a dashboard that gets shared across our organization so staff will know who is covering that area for the day.
The staff listing sheet looks like this:
Any ideas would be super helpful! I may also schedule a pro session for someone to help, I just can't get my brain wrapped around how to make this easy and look nice on the dashboard.
Once I get my grid with the ability to "assign" staff I can get my reports and dashboard created.