'How do I make a character in the external reference string to be variable in excel

Formula: ='[2 AFX - Daily Production Report.xlsx]AFX - Daily Production Report'!$I$7

I want "2" to be variable and will be coming from other cell

variable reference string

stringvariables


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions