CODEWITHSUNDEEP
excellookup
joon25
joon25

Reputation: 41

Excel lookup value in rightmost alphanumeric cell in row

I imagine that I have a row with two kinds of alphanumeric values, one that has 0, and another that has a digit above 0.

If I want to find the rightmost cell that has a value above 0 such as 1, what would the formula be?

enter image description here

Currently I am using the formula =IFERROR(LOOKUP(2,1/(A2:O2<>""),A2:O2),"NS")

but it returns MB0 instead of HB1.

Upvotes: 1

Views: 132

Answers (1)

shrivallabha.redij
shrivallabha.redij

Reputation: 5902

I'd suggest trying like below if number part is always rightmost part of the string.

=IFERROR(LOOKUP(2,1/RIGHT(A2:O2),A2:O2),"NS")

Upvotes: 2

Related Questions