Name | Manager |
Agent 12 | WANT THIS TO POPULATE AUTOMATICALLY BASED ON NAME |
Agent 45 |
<TBODY>
</TBODY>
Ok Will try my best to explain this one but you help would be apreciated,
I want people to be able to choose an agent name then the Manager Cell will populate automatically based on the agent
I have a sheet with a list of all 200 agents and 20 Managers and in a list of who is on whos team team etc
For example
Joe Bloggs (Manager) | John Smith (manager) |
Agent 4 | Agent 22 |
Agent 67 | Agent 134 |
<TBODY>
</TBODY>
What formular do i need so that the manager is returned when an agent name is entered
Many thanks look forward you responses
Emma