EXCEL: USING A CELL VALUE TO REFERENCE A WORKBOOK IN A FORMULA
Posted on 2011-09-19
I have the following formula which perform a Vlookup in a workbook located in a different file:
I would like that the name of the workbook [TEST1.xls] comes form Cell B2... so if I change the value there the Formula will link to a different Workbook...
It's that possible ?
Thank you in advance for your help,