| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUM a Vlookup Array Formula
Hi Dave,
Am Mon, 22 Dec 2014 14:28:12 +0000 schrieb Dave011070: unfortunately it doesn't work for me but I am hoping if you have a few minutes you may see what I am trying to do in the attached spreadsheet. try it with: =SUM(INDEX(Sheet1!A:CA,MATCH(A16&"-"&B16,Sheet1!A:A,0),)) or look he https://onedrive.live.com/?cid=9378A...121822A3%21326 for your workbook Regards Claus B. -- Vista Ultimate / Windows7 Office 2007 Ultimate / 2010 Professional |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to use vlookup in an array formula | Excel Discussion (Misc queries) | |||
| Vlookup array formula problem | Excel Worksheet Functions | |||
| Is there a way do to this without array formula or vlookup | Excel Discussion (Misc queries) | |||
| Use of VLOOKUP function in an array formula | Excel Programming | |||
| array vlookup formula help | Excel Discussion (Misc queries) | |||
Threaded Mode
