使用ISNA判断是否为N/A,是返回true,否返回false,再用if配合
=IF(ISNA(VLOOKUP(D7&"*",$A$2:$B$9,2,0)),"无",VLOOKUP(D7&"*",$A$2:$B$9,2,0))