When i select one person's name, I want to populate their role from a selected table. How can this be done in excel?