PDA

View Full Version : Regarding the Arguments of OFFSET



Cyberdude
10-21-2006, 01:50 PM
When I write:

=OFFSET(C23,-1,1)

it works, but when I write:

=OFFSET(ADDRESS(ROW(),COLUMN()),-1,1)

I get an error. When I write:

=ADDRESS(ROW(),COLUMN())

it displays ?$C$23?. If I give a name like BegSearch to ?C23?, then I can write

=OFFSET(BegSearch,-1,1)

and it works. What rule am I violating?

Bob Phillips
10-21-2006, 04:21 PM
When I write:

=OFFSET(C23,-1,1)

it works,


C23 is a cell referenced here


but when I write:

=OFFSET(ADDRESS(ROW(),COLUMN()),-1,1)

I get an error. When I write:

=ADDRESS(ROW(),COLUMN())

it displays ?$C$23?.

This returns a string.


If I give a name like BegSearch to ?C23?, then I can write

=OFFSET(BegSearch,-1,1)

and it works. What rule am I violating?

Again, BegSearh refers to a cell.

Cyberdude
10-22-2006, 10:31 AM
Aha! Thanks, El (you don't mind me calling you El, do you?). :devil2:

Jacob Hilderbrand
10-22-2006, 05:15 PM
You can add Indirect in your formula to make it take the string as a range. Also you can just start with A1 and offset the number of rows and columns (minus 1 if using Row() and Column()).