Refer to specific cell in a range

[maybeornot]

I would like to have a formula that refers to a specific (offset) cel
in a range. For instance, range is three columns and 20 rows, and
would like to refer to the cell in the first row and the third column.
Should be simple ... Help appreciated

 

[kkknie]

First time I've tried this, but it seemed to work:

=OFFSET(Range1,0,2,1,1)

Where
- Range1 is my defined range.
- 0 means use no row offset (i.e. first row)
- 2 means +2 column offest (i.e. third column)
- 1,1 means return just one row and column (i.e. one cell)