Hallo,
The workbook contains sheets with name containing parenthesis. Ex. (1), (2),...I want to refer to them using the next function but it doesn't work. It works when the parenthesis are removed. The function is: =INDIRECT(CONCATENATE(B2;"!F";B1)).
Cell B2 conains sheet names
Cell B1 contains cell number
The workbook contains sheets with name containing parenthesis. Ex. (1), (2),...I want to refer to them using the next function but it doesn't work. It works when the parenthesis are removed. The function is: =INDIRECT(CONCATENATE(B2;"!F";B1)).
Cell B2 conains sheet names
Cell B1 contains cell number