View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] dave.cuthill@computalog.com is offline
external usenet poster
 
Posts: 53
Default 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