Change reference in formula with dropdown

[Legacy 287389]

Hi good people!,

i'm trying to find a way to replace part of a formula by using a drop down. The formula is this:

='G:\Flash\FLASH 18 - 19\NOV 18\The Ridge Flash\[The Ridge Flash - 21 Nov  18.xlsx]Slots Per Area'!$M$63

the drop down contains a list of months, so if i select "Jun", the "NOV" in the formula must change. is this at all possible?..please help..

NB: the actual days are not a problem as i will fill all cells next to the days in a column with the formula, obviously just changing the days in all of them. thank you kindly..

Something else...the cell reference in the formula displays M63..actually what i would like is the sum of 3 cells, M63, O63 and Q63.

 

[Special-K99]

Dropdowns are linked to a cell arent they? You enter the cell reference when defining the dropdown, e.g. A1

So you'd need to change the formula to

=INDIRECT("'G:\Flash\FLASH 18 - 19"&A1&" 18\The Ridge Flash\[The Ridge Flash - 21 Nov 18.xlsx]Slots Per Area'!$M$63")
or
=INDIRECT("'G:\Flash\FLASH 18 - 19"&A1&" 18\The Ridge Flash\[The Ridge Flash - 21 "&A1&" 18.xlsx]Slots Per Area'!$M$63")

depending if you only want the one NOV reference changed or both the NOV and the Nov reference changed as you've only specified the NOV reference

 

[Legacy 287389]

hello Special-K99,

sorry for coming back only now...thank you very much for your help, greatly appreciated!