automating function change

[leeners82]

I'm wondering if there is a way to alter a function so that each month
a reference in a function changes. More specifically, in this case
every month the file "International Breakdown 'Month' changes so tha
'month' is that current month. Is there a way to have this chang
automated such as referencing another cell where the month is entered?

Here is the current function:
=IF(D10="","",VLOOKUP(D10,'[International Breakdown Month.xls]Re
ss'!$A$7:$L$29,8,FALSE)

 

[Frank Kabel]

Hi
this depends if your file is open or not. If it is open you may use
something like
=IF(D10="","",VLOOKUP(D10,INDIRECT("'[International Breakdown " &
TEXT(TODAY(),"MMMM") & ".xls]Recss'!$A$7:$L$29"),8,FALSE))

BUT if this other file is closed, no way to do this

 

[leeners82]

is there a way to allow the user through a prompt or similar to selec
which file will be used in the function

 

[Frank Kabel]

Hi
not possible within formulas.