| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Variabilize File Path or File Name in SumProduct (and Vlookup too)
In the formula at the bottom, is there a way to "variabilize" the file name
and path so that based on the value of cell the path might be n:\accounting\income audit\automation\lastmonth\[dailyinput.xls] or perhaps the filename would be different: n:\accounting\income audit\automation\[dailyinputDec.xls] =SUMPRODUCT(('N:\Accounting\Income Audit\Automation\[DailyInput.xls]InfoGenesis'!$C$10:$C$575=$A7)*('N:\Accounting\Inc ome Audit\Automation\[DailyInput.xls]InfoGenesis'!$B$10:$B$575=$B7)*('N:\Accounting\Inc ome Audit\Automation\[DailyInput.xls]InfoGenesis'!D$10:D$575)) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Inserting File Path name | Excel Discussion (Misc queries) | |||
| Formula too long - new file path is shorter than old file path - Excel 2003 | Excel Worksheet Functions | |||
| file path | Excel Discussion (Misc queries) | |||
| file path | Excel Discussion (Misc queries) | |||
| Excel updating from XML file - file path specific? | Excel Discussion (Misc queries) | |||
Threaded Mode
