假设我有这个。
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?