precisiongreen32
New Member
- Joined
- Jan 18, 2019
- Messages
- 1
Looking for help. I would like to create a formula that would pull in employees name/s. I have a database I type in employees names and the route each person is assigned to. Each route has its own tab. I want he employees who belong on the route/tab to auto populate. The crew may be one or 6 people.
=IFERROR(INDEX(staff2!$E$2:$E$80,SMALL(IF($D$3=staff2!$A$2:$A$80,ROW(staff2!$E$2:$E$80)-1,""),ROW()-7)),"")
this is the formula I have. I can get it to work, but when I change the tab name it quits working. I need to put the formula in the 12 boxes that is where the employees name go. Then I copy the "template" tab rename it to whatever the route name is.
=IFERROR(INDEX(staff2!$E$2:$E$80,SMALL(IF($D$3=staff2!$A$2:$A$80,ROW(staff2!$E$2:$E$80)-1,""),ROW()-7)),"")
this is the formula I have. I can get it to work, but when I change the tab name it quits working. I need to put the formula in the 12 boxes that is where the employees name go. Then I copy the "template" tab rename it to whatever the route name is.
