M
mrhartwig
Hello All. I am trying to pull employee's names from one worksheet
to
another but only if they are active and work in a particular
location.
Column A: Active or Inactive status
Column B: Location
Column G: EE Name
Here is what I have tried:
=Index('CPC Roster'!G2:G5,Match(1,('CPC Roster'!A2:A5="Active")*('CPC
Roster'!B2:B5="BURBANK"),0))
This sort of works except when it comes to a name that is not active
it repeats the name above until it reaches an active one.
I've also tried:
=LOOKUP(2,1/('CPC Roster'!A2:A10="Active")/('CPC Roster'!
B2:B10="BURBANK"),'CPC Roster'!G2:G10)
For some reason this skipped a handful of people in the first few
rows
and still repeated names.
What I really need it to do is only bring over the active employees
and skip the inactive employees. Does anyone have any suggestions?
Thanks so much.
--Michelle
to
another but only if they are active and work in a particular
location.
Column A: Active or Inactive status
Column B: Location
Column G: EE Name
Here is what I have tried:
=Index('CPC Roster'!G2:G5,Match(1,('CPC Roster'!A2:A5="Active")*('CPC
Roster'!B2:B5="BURBANK"),0))
This sort of works except when it comes to a name that is not active
it repeats the name above until it reaches an active one.
I've also tried:
=LOOKUP(2,1/('CPC Roster'!A2:A10="Active")/('CPC Roster'!
B2:B10="BURBANK"),'CPC Roster'!G2:G10)
For some reason this skipped a handful of people in the first few
rows
and still repeated names.
What I really need it to do is only bring over the active employees
and skip the inactive employees. Does anyone have any suggestions?
Thanks so much.
--Michelle