CELLREF(N1, N2)

Description
This function returns a reference to the cell whose column index is N1 and whose row index is N2. Column indices start with 0, so the column index for column A is 0, B is 1, etc. Row indices are the same as the row number, and therefore start with 1.

Note: CELLREF columns are zero-based. That is column A is column 0, B is 1 etc. Rows are the same as displayed on the row header.

Parameters
N1
A numeric value

N2
A numeric value

Examples

CELLREF(3, 1) = -80
where D1 = -80

CELLREF(27, 34) = 2400
where AA34 = 2400

CELLREF(4, 8) = 100.00
where E8 = 100.00