Change to the last number in a list

I have a column of numbers and daily add a new number to the bottom of the list.

In a separate reference cell (B1002) I have

=(1001-COUNTBLANK(B2:B1001))

This gives me the number of cells in the range that have numbers in them.

Then in cell B1003 I have

=ADDRESS(B1002,2)

This gives me the absolute reference of the bottom cell in the list that has a number in it.

I am simply trying to convert that absolute reference into a formula in another cell so that I have a cell containing the same number as is in the last cell used in the column.

The answer to this simple little challenge continues to elude me.

Hi,

All you need to do is use the following:

PHP Code: 

=INDIRECT(ADDRESS(B1002,2)) 


S