Obtain the value in a cell offset form the first cell of a named range
I am trying to figure out a formula which obtains the value of a cell which is offset from the first cell of a named range.
I have tried something like this =OFFSET(RngName,-13,3)
but I get a #REF! error.
David
|