Hi all,
I've tried to create a dynamic formula to reference the cell between 2 separate worksheets. Please refer to attached and advise the error on the formula in cell D6 (=(INDEX(CONCATENATE("'[",A6,"]",B6,"'!",C6),4,2)) of workbook "Test1.xlsx".
Thanks in advance for the help.
2019-07-29_13-10-40.png
2019-07-29_13-11-59.png
Bookmarks