Retrieve data from last row / cell in Dynamic Range

  • I am attempting to retrieve the value found in the last cell/row in column E of a dynamic range. The first row containing data will always be E12 and the last row fluctuates on a daily basis. The formula I am using invariably returns the value found in E12 only - so I am obviously doing something drastically wrong...


    I am using a Named Range to house the formula.


    Also, the data in column E is obtained via a VLOOKUP, which is why I'm using "value" in the formula.


    I am in a corporate setting - Macros / VBA Code not allowed...


    Any insight would be greatly appreciated!


    Thanks in advance...


    Code
    1. 'Named Range = Last_Roe_ColE
    2. =value($E$12:INDEX($E:$E,COUNTA($E:$E)))
  • "1 posts so you should have read our rules and understand about cross posting. Your post has been reported for cross posting, please provide a list of all other forum posts