Last Cell in Range Formula

[RobertCotton]

Good Morning.

I need a formula in Excel 2007 that will select the value in the last cell in a range of cells.

The spreadsheet data looks like this
A1=5
A2=10
A3=15
A4=8
A5=3

I want to use a formula on a seperate tab that will show the value in A5. Can anyone help me with this?

Thanks

 

[VoG]

Try

=LOOKUP(9.9E+307,Sheet1!A:A)

 

[T. Valko]

Good Morning.

I need a formula in Excel 2007 that will select the value in the last cell in a range of cells.

The spreadsheet data looks like this
A1=5
A2=10
A3=15
A4=8
A5=3

I want to use a formula on a seperate tab that will show the value in A5. Can anyone help me with this?

Thanks

Try this...

Assuming the data is on Sheet1.

=LOOKUP(1E100,Sheet1!A:A)