vettetax
New Member
- Joined
- Jul 5, 2006
- Messages
- 47
=INDEX('F:\Financials-MonthlyData\2008\Fiserv 2008 Monthly Financials\MPC Supp Workbook\[May 2008 MPC Supp Workbook.xls]Forecast'!$B$19:$M$19,1,$G$1)
In this formula, is there a way to make "May" a variable? By making use of a vlookup perhaps? So if G1 is 5, I want the link to point to the May file, if 6, the June file, if 7, the July file, etc.
In this formula, is there a way to make "May" a variable? By making use of a vlookup perhaps? So if G1 is 5, I want the link to point to the May file, if 6, the June file, if 7, the July file, etc.