This worked, (much simpler than the other suggestion) but I wonder why? What
is the purpose of +307? In my case, 99.99999999 +nothing worked just fine.
I'm just wondering how and why the formula works?

Thanks,
McH


"Aladin Akyurek" wrote:

Wouldn't

=LOOKUP(9.99999999999999E+307,Range)

do the job?

samfw wrote:
I need to write a formula in one cell that inserts the last used value from a
range of cells. My range of cells represents monthly values. So, for
example, if I have only posted values through July then only the first seven
cells will have values and the value I want to insert is the July or 7th
value.