行中最右边的字母数字单元格中的Excel查找值 [英] Excel lookup value in rightmost alphanumeric cell in row

问题描述

我想象我有一行包含两种字母数字值，一种具有0，另一种具有大于0的数字.

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.

如果我想找到值大于0(例如1)的最右边的单元格，公式将是什么?

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

当前，我正在使用公式= IFERROR(LOOKUP(2,1/(A2:O2 <>")，A2:O2)，"NS")

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

但是它返回MB0而不是HB1.

but it returns MB0 instead of HB1.

推荐答案

如果数字部分始终位于字符串的最右边，我建议尝试如下所示.

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")

这篇关于行中最右边的字母数字单元格中的Excel查找值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！