Ok how do you lookup the last alpha numeric value in a column L ?

"Max" wrote:

Assuming source data is in row 2,

Put in say, A3 and array-enter the formula,
ie press CSE* instead of just pressing ENTER:
=INDEX(2:2,MAX((2:2<"")*COLUMN(2:2)))

*CSE = CTRL+SHIFT+ENTER
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"BAKERSMAN" wrote:
I need to look up the last alpha numeric value in a row.