Use of VLOOKUP function in an array formula

J

jaxgab

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?
 
S

ssGuru

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?
Click to expand...

Try SUMPRODUCT
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Array Formula In IF Function 0
Excel Wildcard in Excel array formula 0
Getting the next higer value with Vlookup - True 5
Vlookup error 1
Calculate the result of an array in vba 1
Is it Possible to have a dynamic function in an array written in visual basic? 6
Copy Array to Array, how to and should I? 13
Why are the two codes below not getting the right formula for myworksheet event change formula? 2

Top