Answer the question
In order to leave comments, you need to log in
How to get the contents of a cell if its address is given by a formula?
This is how I'm trying to do it.
"INDIRECT(ADDRESS(ROW()+3;COLUMN()+2;4;FALSE);FALSE)" doesn't take value from desired cell. I hope there are problems in skiing
))
Answer the question
In order to leave comments, you need to log in
Solution found. use)
=IF(TODAY()-INDIRECT(ADDRESS(ROW();COLUMN()+10;4;TRUE);TRUE)>3;TRUE();FALSE())
The problem was that INDIRECT understands what "O3" but does not understand links in the format "R[3]C[25]"
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question