I am working with the below formula and have 30 references to maintain. Is there a way to modify this formula to reference the 111 in cell C2 versus manually typing the files in each formula? The key for this workbook is to provide an array function that will permit the referenced files to remain closed.

VLOOKUP(O$7,'S:\Financial Analyst\Budgets\2011 Facilities\Published\[111 2011 Budget Allocation.xls]Facility Budget'!$A$7:$V$500,20,0)

Thank you.