I need some help with an Excel 2007 spreadsheet. (see attached)
I have 2 worksheets that I am using to automatically populate a third worksheet.
Here is a description of the worksheets:
List of employee names and info as well as the group number they are assigned to.
List of Managers and their assistants as well as the group number the manager is responsible for.
Each group is populated based on the data entered in the other 2 worksheets.
The problem I am having is that I would like to pull all of the names from the Employees worksheet based on the group number they are assigned.
Here is the function I am using but it is not working:
Any assistance that can be offered would be appreciated.