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
=value($E$12:INDEX($E:$E,COUNTA($E:$E)))