Excel 2007比较同一行中的两列

时间:2023-01-04 13:17:11

I have c2 with list names starting with state abbreviations. Then I have e2 with state abbreviations.

我的c2列表名称以州缩写开头。然后我有e2状态缩写。

I need to input a formula into b2 that compares for the same row only and returns a matched or unmatched value.

我需要在b2中输入一个公式,仅比较同一行并返回匹配或不匹配的值。

I had this figured out already, but I can't seem to get it working again.

我已经想到了这一点,但我似乎无法让它再次运作。

1 个解决方案

#1


0  

How about:

=IF(LEFT(C2,2)=LEFT(E2,2),"match","unmatch")

#1


0  

How about:

=IF(LEFT(C2,2)=LEFT(E2,2),"match","unmatch")