Hi, I am working on an inventory accounting system. I have 4 different stock locations. For each stock location I am maintaining a separate excel file. The files are named "STKLD_" followed by the location. As part of the transaction, the user has to select the stock location from which the stock is being issued/received. I am capturing the stock location in column D. In column F I want to display the stock on hand for that item in that particular stock location. When I was using only one stock location, the formula 
=IF(ISBLANK(B9),"",IF(ISERROR(MATCH(B9,[STKLD_STORES.xls]Stk_Status!$B$4:$B$50000,0)),0,VLOOKUP(B9,[STKLD_STORES.xls]Stk_Status!$B$4:$Z$50000,3,FALSE)))
worked very well. In my current requirement, I need STKLD_STORES.xls to replaced with "STKLD_<cell D9 value>.xls".

I need help on how I can achieve this.