Enter IF( between the = and ISNA formula. The formula looks like this: =IF(ISNA(VLOOKUP(B4, C$4:C$9, 1, FALSE)) · Enter B4, right after the VLOOKUP formula, that ...
確定! 回上一頁