Forum Discussion
Solved
Is it possible to use the ADDRESS function within the CELL functiion?
I would like to use the ADDRESS function within the CELL ("contents") function to access a cell's contents based on a constructed address. This will be used to copy data from a sheet containing a ...
CELL's signature is looking for a reference. ADDRESS returns text. You'd need to convert the results of ADDRESS to a reference as such:
=CELL("contents",INDIRECT(ADDRESS(1,9+A1,4,1,"T")))My thoughts are if you're going to use the above, you might as well simply use INDIRECT.
CELL's signature is looking for a reference. ADDRESS returns text. You'd need to convert the results of ADDRESS to a reference as such:
=CELL("contents",INDIRECT(ADDRESS(1,9+A1,4,1,"T")))
My thoughts are if you're going to use the above, you might as well simply use INDIRECT.
INDIRECT(ADDRESS( . . . ) worked just fine! As you suggest, I'll look into just using INDIRECT. (Simpler is always better).
Many thanks for the quick response.
Jude
- You're welcome!
