如图:B2中=COUNTIF($C$2:$C$27,"*"&B2&"*")公式无法实现用if、find()函数怎么实现不甚感激,谢谢用什么函数可以实现
B2=-LOOKUP(,-FIND($D$2:$D$22,A2))
或者=IF(ISERROR(LOOKUP(,-FIND($D$2:$D$22,A2))),"否","是")