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