CELLREF

**Syntax:** **CELLREF( N1, N2)**

*N1* = a numeric value

*N2* = a numeric value

**CELLREF** 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.

**Examples:**

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

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

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

**Excel function:** *N/A*

Grey Trout Software

02 March 2003