=IF(ISNA(VLOOKUP(A2,$D$2:$D$4,1,FALSE)),"No","Yes") Vlookup values in a shorter list and ... If Vlookup formula: if not found return 0.
確定! 回上一頁