Oct 15 2019 09:49 AM
Hello,
I'm having some trouble and I'm hoping the kind people here can help. I'm using the ADDRESS function to generate the cell address of a cell in a separate sheet. I have the sheet name (Sheet 1) in cell Q4, and in R4 I have =ADDRESS(ROW(INDIRECT("'"&$Q$4&"'!"&"C12")),COLUMN(INDIRECT("'"&$Q$4&"'!"&"C12"))). This gives me the address of the cell I'm trying to reference, which is cell C12 in the sheet titled Sheet 1 as specified in Q4. However, if I were to insert a new row above my reference cell C12 in Sheet 1, this does not get converted in cell R4, Sheet 2. I want it to lock to that specific cell so it changes to C13, but the reference stays on C12. Also, is there a way to make it so that if I were to drag R4 in Sheet 2 across to R5, it would change my corresponding result from C12 to C13?
Thanks for any and all help, I'm sorry if this is confusing I tried to explain as best I can.
Oct 15 2019 10:32 AM
Oct 15 2019 11:26 AM
Oct 15 2019 11:45 AM