Using Text as an External formula link

[Magee]

Hi All

sorry about hte description...

Is there a way of using text in a cell to use in a forluma.

For example, I have a spreadsheet that contains the current month in Cell D1.

I have different spreadsheets, saved in the same place but are named:

January Sales
February Sales
March Sales
Etc...

What I would like to do is used the text (April) in Cell D1 to replace the April in the following Formula. Then Whenever I change the month in Cell D1 the formula will change looking up the correct spreadsheet?

='[April Sales.xlsx]Sheet1'!$D$9


Hope this makes some sort of sense?

 

[GlennUK]

Using the INDIRECT function will work, but only if you are willing to have the supporting workbook open at the same time. Otherwise you will need a third party add-in .. like MOREFUNC from Laurent Longre, which has the INDIRECT.EXT function.

Download here:
http://xcell05.free.fr/downloads/Morefunc.zip