Get cell value by address string in Numbers

numbers

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?

Best 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.

Related Solutions

Copy static cell value in Numbers

You need to use the $ char e.g. like this: =$D$3

Numbers: VALUE function does not recognize empty string

IFERROR(VALUE(<cell>),0)

would return 0 for an empty cell (or any string that can not be converted into a value). I tried something like:

= MAX (I5, (0.5 x (IFERROR(VALUE(J5),0)))

and my initial tests were working.

Hope this helps

Best Answer

Related Solutions

Copy static cell value in Numbers

Numbers: VALUE function does not recognize empty string

Related Question