Multiple Column look up
In addition to my question, here is the formula I used, which didn't work.
=SUMPRODUCT(--(BU=U118),--(GL=Y118),--(AC=X118),Cat) The BU, GL, AC and Cat are names of my ranges. Please help. |
Multiple Column look up
Make sure that the sizes for each range are the same. Also, unless
you're using Excel 2007, SUMPRODUCT will not accept whole column references. Hope this helps! http://www.xl-central.com In article , Multiple Column look up wrote: In addition to my question, here is the formula I used, which didn't work. =SUMPRODUCT(--(BU=U118),--(GL=Y118),--(AC=X118),Cat) The BU, GL, AC and Cat are names of my ranges. Please help. |
All times are GMT +1. The time now is 02:35 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com