| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| array function vlookup | Excel Discussion (Misc queries) | |||
| Is there a way do to this without array formula or vlookup | Excel Discussion (Misc queries) | |||
| How to define table array in Vlookup function using VBA? | Excel Programming | |||
| Array Function with VLOOKUP | Excel Worksheet Functions | |||
| How to use a cell value as Table Array in VLOOKUP worksheet function | Excel Discussion (Misc queries) | |||
Linear Mode
