Hi, If the current Index/Match formula states:
"=INDEX('Y:\Brian\Payroll\[Payroll Commission P12 FirstSemi.xlsm]Payroll Summary'!$B:$B,MATCH(A2,A:A,0))"
How can I reference the "P12" to a cell let's say B2, which contains text "01"
The result will be
"=INDEX('Y:\Accounting Library\Brian\Payroll Commission\[Payroll Commission P01 FirstSemi.xlsm]Payroll Summary'!$B:$B,MATCH(A2,A:A,0))"
I tried to use INDIRECT formula which works but it won't work for a closed workbook that it's referencing to.
Please help, Thanks!
Bookmarks