Forum Discussion
Excel cell value from address
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(...
You can use the INDIRECT function:
=INDIRECT(ADDRESS(P4,13))
or, since column 13 is M, use
=INDEX(M:M,P4)
- Duh! Yes! OF COURSE the INDIRECT function! It IS indirect addressing, just like in machine language programming. Anyway, to be clear, it works! Thank you, both. (I'll try INDEX, too, just to try it.)
