Path Variable in Formula

[JLouis]

I have a VLOOKUP formula in a worksheet as follows:
"=VLOOKUP("Total Disc / Coup",'M:\Dropbox\1 Administration\NEW MONTHLY EXTENSIONS 2022\MONTHLY GL\7\[276.dsr.xls]Sheet1'!$A$1:$P$22,9,FALSE)"
I've created a named cell reference on another sheet names "periodx" where the number 7 is located but the number changes based on the month. I'm looking for help writing the formula to use the correct numbered reference depending on the month such as:
"=VLOOKUP("Total Disc / Coup",'M:\Dropbox\1 Administration\NEW MONTHLY EXTENSIONS 2022\MONTHLY GL\"& periodx &"\[276.dsr.xls]Sheet1'!$A$1:$P$22,9,FALSE)"

Thank you in advance.

 

[JLouis]

It does have a formula in it, but I can get the number directly entered upon opening. I'll do that and post the results.

 

[Fluff]

Thinking about as the other workbook will be open, you can just use

=VLOOKUP("Total Disc / Coup",'[276.dsr.xls]Sheet1'!$A$1:$P$22,9,FALSE)

 

[JLouis]

OK, I just entered a 7 into the cell (formatted as a number) and still get a #REF error code with the formula.

 

[JLouis]

Yippee, your new formula worked perfectly. Thank you so much for taking your time to help!

 

[Fluff]

You're welcome & thanks for the feedback.