Sorry guys. Both of your functions produce the same results but not what I'm
after. I need for the result to return what was last TEXT in the column ABOVE
or IN that particular row where the function is...not what is in the very
last cell of a column.

"Ron Rosenfeld" wrote:

On Mon, 6 Oct 2008 15:14:11 -0700, VSlaybaugh
wrote:

In any cell of column C of Sheet 2, I want it to return the last non-blank
cell from Sheet 1 Column D...being the last non-blank cell in or ABOVE that
row. Column D in sheet 1 has TEXT and no numbers. My range I'm working from
on sheet 1 is D7:D7000.


=LOOKUP(2,1/(LEN(D7:D7000)0),D7:D7000)

--ron