In Numbers 3.5.2 I manage to get a cell address sting (I compute it based on some data). Now when I have it, how can I get the value behind that address without copying the result of my function to the another cell and adding =
before it?
1 Answer
There's the INDIRECT function, which returns the contents of a cell or range referenced by an address specified as a string.
example:
INDIRECT("B2")
Here's Apple documentation about Numbers.app functions.