Hello All,
I would like to know how I could change the cell address in a formula without having to edit the address.
Example:
Month listed in range C4:N4 (one month per column)
In the cells listed below each month is data that I would like to reference into a summary page.
The existing addresses are
='U:Inventory Reporting\[2005 PLN Inventory.xls]Monthly DOH'!$E$11
='U:\Inventory Reporting\[2005 PLN Inventory.xls]Monthly DOH'!$F$11
='U:\Inventory Reporting\[2005 PLN Inventory.xls]Monthly DOH'!$G$11
='U:\Inventory Reporting\[2005 PLN Inventory.xls]Monthly DOH'!$H$11
etc...

Each month I must manually change the cell address column letter to extract the data.
Is it possible to write a formula that will change as the month reference changes?

I have got as far a getting the cell reference column to change but it will not work as a formula should.
My attempt is

Final result:- =U:\Inventory Reporting\[2005 PLN Inventory.xls]Monthly DOH'!$E$11
Column reference:- =CHOOSE(MID($W$13,FIND(" ",$W$13,1),3),3,4,5,6,7,8,9,10,11,12,13,14)
Path to address:- U:\Inventory Reporting\[2005 PLN Inventory.xls]Monthly DOH'!

Any advise would be appreciated or a better idea.

Thank you and best regards

Max