Using Text as an External formula link

Magee

Board Regular
Joined
May 14, 2009
Messages
95
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?
 

Some videos you may like

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.

GlennUK

Well-known Member
Joined
Jul 8, 2002
Messages
11,402
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
 

Watch MrExcel Video

Forum statistics

Threads
1,108,624
Messages
5,523,963
Members
409,547
Latest member
AW2020

This Week's Hot Topics

Top