1,取得excel文件名函数(含文件后缀名)
=MID(CELL("filename"),SEARCH("[",
CELL("filename"))+1,
SEARCH("]",
CELL("filename"))-
SEARCH("[",CELL("filename"))-1)
2,判断B2单元内容在A2-A90单元格内是否存在
=IF(ISERROR(VLOOKUP(B2,$A$2:$A$90,1,FALSE)),"x","0")
目标 判断范围