|
|
|
|
#1
11-02-2016, 11:53 AM
|
|||
|
|||
I don't think I fully understand the problem.
In the file ExcelForum DateRangeArrays_3, sheet Activity cell C12, "Plant down" is returned which you say is incorrect. What should be returned then? If I look at the same row in file Forum_Test I can see that your SUMPRODUCT function in AT12 returns 3 which is the same as my SUMPRODUCT function returns (ExcelForum DateRangeArrays_3, sheet Activity cell C12). Can you please try again to explain exactly what determines which text should be returned. 
|
|
| Tags |
| excel 2013 formula |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Excel - Index and Match Function ,First Second and Third Match | paulzy95 | Excel | 10 | 09-29-2016 10:46 PM |
| Translate INDEX(MATCH) into VBA | grexcelman | Excel Programming | 1 | 03-08-2015 05:06 PM |
| Index match vba | grexcelman | Excel | 0 | 03-05-2015 10:55 PM |
| Index Match syntax | grexcelman | Excel Programming | 0 | 03-05-2015 07:17 AM |
| UDF multiple IFs INDEX-MATCH | grexcelman | Excel Programming | 0 | 02-22-2015 04:20 PM |
Index match two date ranges
Windows 10 
Office 2016
Hybrid Mode