Search for data in the last row

[corinereyes]

Hi People,

Sorry, i already searched for a solution same as this but i can't find it anymore. So here it goes.

Say i have a1:a10 with names on it. I need to return the last name in the row and display it in another cell.

Thanks in advance.

Corine

[martindwilson]

=LOOKUP(REPT("z",255),A1:A10)

[corinereyes]

Thanks martin! Perfect!