=IF(ISNA(VLOOKUP(A2,$D$2:$D$4,1,FALSE)), "No", "Yes"). 3. Select the result cell, and then drag the Fill Handle to apply the formula to other cells (In this ...
確定! 回上一頁