假设我有这个。
Words Mark Suffix
Happily ly
Emotional dom
Emotionally
Surfdom
如果单词在后缀列表中以某些后缀结尾，我想标记为1，否则为0。
Words Mark Suffix
Happily 1 ly
Emotional 0 dom
Emotionally 1
Surfdom 1
I tried lookup and vlookup but they are incomplete. How can I do this?
If those three columns are A,B & C then B2 =
=IF(OR(RIGHT(A2,LEN($C$2))="ly",RIGHT(A2,LEN($C$3))="dom"),1,0)如果您在C列中有大量数据，则此方法不合适。在这种情况下，您可能需要VBA解决方案。