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.
"=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.