Thanks, worked just like I wanted it to
--
RedFive


"Mike H" wrote:

Hi,

=INDIRECT("A"&SUMPRODUCT(MAX((ROW(A1:A1000))*(A1:A 1000<""))))

or if you know its a number
=LOOKUP(10^23,A:A)

or if you know its text
=MATCH(REPT("z",255),A:A)

Mike

"RedFive" wrote:

I am trying to write a formula that will recognize the last populated cell in
a given column, and then display what is in that cell. Is there a function
that will recognize the last populated cell in a given column?
--
RedFive