I tried your formula and of course it works. Just curious. What is the
significance of "2" in the formula?

Also the "1/". . .)?

"Rick Rothstein" wrote:

Try this formula...

=LOOKUP(2,1/(C1:C14<""),C1:C14)

--
Rick (MVP - Excel)


"Ahmed Khan" <Ahmed wrote in message
...
Am using MS-2007. Pls provide me the formula to get the last column
value.

c5 123
c6 126
c7 128
c8 124

c15

I want "C15" to automatically catch the value of the last column value in
the column (c8). Pls help me