Hi David,

Am Mon, 23 Nov 2015 11:13:49 -0800 (PST) schrieb
:

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)

you have to create the OFFSET from the first cell of your range.
Try:
=OFFSET(INDEX(rngName,1),-13,1)


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional