ExcelBanter - Use of VLOOKUP function in an array formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Use of VLOOKUP function in an array formula (https://www.excelbanter.com/excel-programming/394588-use-vlookup-function-array-formula.html)

[email protected]

Use of VLOOKUP function in an array formula

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?

ssGuru

Use of VLOOKUP function in an array formula

On Aug 1, 1:50 pm, wrote:
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?

Try SUMPRODUCT

All times are GMT +1. The time now is 10:23 PM.