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