I am searching for a formula that needed to show always last cell value filled in Colum A which should display in D6

Example:

A.......D
23 185
10
25
18
5
185


When user first inputs 23 in A1 cell, D1 should display value 23. If A2 is filled up with another value (say 25) D1 should display 25. Likewise when 18 , 5, 185 and so on. In other words, last cell value of A column should apprear in cell D1

How can I do that? Appreciate your help...

Thanks,
Ashfaque

=VLOOKUP(999999,A:A,1)

this will do this for you , it uses the Range_lookup of True which in normal practice needs the data to be in ascending order, if the data is not and the search value is not found then the last value in the list is returned, so the search value must be set to a larger value than can occur.

Brian

Thanks Brian,

Appriciate quick response.

It might be better if it could produce real value of last cell from the range and not TRUE or FALSE.

:confused:

What I posted will display the value, atleast it does in my test.

Brian

It produces TRUE or FALSE. I am using Excel 2007.

I need the value to appear is it entered in last cell of range.

Thanks,
Ashfaque

I don't know what you have done since you merely repeat yourself. I don't have 2007 but cannot see how you are getting TRUE or False,
I have attached a simple example of my suggestion working.

Brian

Excellent...

Thanks Brian....

Ashfaque