I want to be able to populate cell B1 based on the value entered into cell A1. Cell A1 is a drop down list with values set up in a range on worksheet 2. Cell A1 is the associates name. I want cell B1 to be the associates manager.
On worksheet 2, in column A are all the associates names, in column B is the associates manager.
What I would like to happen is when I select a name (on worksheet 1) from the drop down list, the managers name would auto populate.
Thanks for any help.
On worksheet 2, in column A are all the associates names, in column B is the associates manager.
What I would like to happen is when I select a name (on worksheet 1) from the drop down list, the managers name would auto populate.
Thanks for any help.