I would like to be able to use cell (B1) to change the file name referenced in a lookup formula.
Example: A1 contains a company number "503"
A2 is a lookup from March's sales file =VLOOKUP($A1,'C:ACCTSALES[March.xls]Sheet1'!$A$4:$M$184,2,FALSE)
I would like to replace the [March.xls] with a cell reference within my file so that I can change my lookup by changing "March.xls" to "April.xls".
_________________
Thanks
rkeithg
This message was edited by rkeithg on 2002-04-10 12:13
Example: A1 contains a company number "503"
A2 is a lookup from March's sales file =VLOOKUP($A1,'C:ACCTSALES[March.xls]Sheet1'!$A$4:$M$184,2,FALSE)
I would like to replace the [March.xls] with a cell reference within my file so that I can change my lookup by changing "March.xls" to "April.xls".
_________________
Thanks
rkeithg
This message was edited by rkeithg on 2002-04-10 12:13