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.
Any insight would be greatly appreciated!
Thanks in advance...
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.
Any insight would be greatly appreciated!
Thanks in advance...
Code:
'Named Range = Last_Row_ColE.
=value($E$12:INDEX($E:$E,COUNTA($E:$E)))