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...

    'Named Range = Last_Roe_ColE
  • "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

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!