how to add strings to address?
I have this as an address $Weekly.$P2, where column letter changes according to cell A49.
A49 contents change to other column letters. How to add contents of A49 to $Weekly.$(A49)2?
I have tried to use INDIRECT. $Weekly.$INDIRECT(A49)&"2", but I get an error.