Obscure Function

K

KW_Counter

I used to use a function where a formula would look in a cell to find what
column or row it should use in the formula. Anyone know what this is callled?
Thanks,
KW_Counter
 
J

JLatham

Stabbing around somewhat blindly...

INDIRECT() - uses the value in the referenced cell as an address.
ROW() returns the row of the referenced cell
COLUMN() returns the column of the referenced cell
where "referenced cell" is the cell address within the () of those functions.
 
D

Duke Carey

Also, Index() and Offset()

JLatham said:
Stabbing around somewhat blindly...

INDIRECT() - uses the value in the referenced cell as an address.
ROW() returns the row of the referenced cell
COLUMN() returns the column of the referenced cell
where "referenced cell" is the cell address within the () of those functions.
Click to expand...
 
Top