May 24 2022 11:16 AM
I know I'm doing something dumb. I have a vector of row numbers. I can use them and column numbers in the ADDRESS function to return Excell addresses containing a number I want to get, e.g., ADDRESS(P4,13) returns $M$722. (P4 is the cell that contains the number 722, in the vector of row numbers.) What I really want is the number/contents in cell $M$722. I can figure out how to take the cell address to return the number. It seems like the $M$722 is acting like it is text.
May 24 2022 11:23 AM
May 24 2022 11:28 AM
You can use the INDIRECT function:
=INDIRECT(ADDRESS(P4,13))
or, since column 13 is M, use
=INDEX(M:M,P4)
May 24 2022 12:19 PM