How to do this formula?!

[jimmy]

Hello,

would like to know if someone can help me.

My question is:

Which formula i have to use to have in one of the excel sheet thee last
value that appeared in another sheet?

Exp:
In the sheet 1 i have a set of values
day 1 = 20
day 2 = 30
day 3 = 40
Today = 60

In the other sheet i have to use a formula that calculates the result with
the today´s value.

Well, i think there is a way of doing that automatically without change
everyday the the cells in the formula.

If someone could help!!

Thanks

 

[Gaurav]

Following will return the last value entered in the column.

=LOOKUP(2,1/(A1:A65535<>""),A1:A65535)

If you want it to be a part of another formula, please post your current
formula here.

 

[BoniM]

=LOOKUP(99^99,B:B)

Will return the last value entered in column B - adjust as necessary.