For numeric values try

=LOOKUP(9.99999999999999E+307,A:A)

Change the column to suit

Mike

"gwbdirect" wrote:

I need a formula that will show the last cell in a range.
1000
2000
3000

want to show 3000 as the result and not the total of everything in the
column!!!