When I try the following array formula, the correct answer is not
returned:

=SUM(('PY Labor Distribution'!$A$7:$A$1000=$C8)*
(VLOOKUP('PY Labor Distribution'!$C$7:$C$1000,Names!$B:$F,
5,FALSE)="Southwest")*
('PY Labor Distribution'!$E$7:$E$1000))

Is it against the "rules" to use VLOOKUP in an array formula?