Thread: Variabilize File Path or File Name in SumProduct (and Vlookup too)
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H. Mike H. is offline
external usenet poster
  
Posts: 471
Default 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))


Reply With QuoteReply With Quote