Hi,

assuming you are looking for the item in column D:

Last Number: =LOOKUP(9^9,D:D)
Last Text enry: =LOOKUP(REPT("z",255),D:D)
Last Non-blank cell: =LOOKUP(2,1/(B:B<""),B:B)
--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Eddie" wrote:

How to get a value of data from the last rows of a table. sheet1 content a
data table. Data rows is increasing daily. Sheet2!A1 is showing the last data
entered in sheet1.

All this while i am using =sheet1!$D100 to get the data, but I need to
update the formula daily. Is there any formula for this situation?