specify row number in Offset

scorpweb

Board Regular
Joined
Jul 26, 2011
Messages
124
Hey All,

I have an offset range i am trying to call based on a cell with the value of 60. (this is declared as offset2)

I want the offset to look in Row 60 etc.

I know i can do .offset(-1,0) etc. but is there a way to tell it to just check that row? as oppose to the +1, -1 stuff

thanks
 

Some videos you may like

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.

Watch MrExcel Video

Forum statistics

Threads
1,109,447
Messages
5,528,803
Members
409,837
Latest member
karnasrinivas
Top