I am using an indirect reference to text with parentheses in it. How can I format it to recognize the parentheses as simple text and not cause a #ref! error. formula looks like this: =if(isnumber(index(indirect($P38&"!1:1048576),match...
Solved by S. L. in 25 mins