Lookup the last alpha numeric value

[Guest]

I need to look up the last alpha numeric value in a row.

 

[Guest]

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

 

[Guest]

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

 

[Guest]

Array-enter in say M1:
=INDEX(L1:L65535,MAX((L1:L65535<>"")*ROW(1:65535)))

 

[Guest]

This is pulling the first alpha numeric value, is there a way to pull that
last value.

 

[Ragdyer]

Try this:

=LOOKUP(2,1/(L1:L65535<>""),L:L)

 

[Guest]

This is pulling the first alpha numeric value, is there a way to pull that
last value.

I lost you there. Doesn't the earlier extract the last value in col L?

---

 

[Max]

Don't forget the "array-enter" bit, it makes a world of difference

---