Refer to specific cell in a range

  • Thread starter Thread starter maybeornot
  • Start date Start date
M

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
 
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)
 
Back
Top