Get value from another cell using Offset and active cell

[Rick_Stanich]

I can do this in VBA but I cant seem to do it on a worksheet.
Lame, I know.

Please Login or Register  to view this content.

I would like for the above to allways look in Column "A" and one row down from the active cell.
I know how to use "OFFSET(reference,rows,cols)". What I dont know how to do is get the active cell "reference" address. The active cell can change.

Any hints, tips, or examples are appreciated.

[teylyn]

Maybe

=OFFSET(INDIRECT("A"&ROW()),1,cols,...)

[teylyn]

Or forget about offset,

="Ref: #" & INDIRECT("A"&ROW()+1)

[shg]

Or ="Ref: #" & INDEX(A:A, ROW()+1)

[Rick_Stanich]

Teylyn
Your first suggestion didnt work but your second does just fine.

shg
Yours works as well.

Neat how different methods not only work and are available.
The "Indirect" method seemed to work from the cell where the "Index" highlites the column (A) with some type of outline box when you are in the formula bar.

Either way, Thank you both!