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.