Get cell value by address string in Numbers
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.