In earlier versions of Excel that lack the IFERROR function, you'll need to repeat the VLOOKUP inside the IF function: =IF(ISNA(VLOOKUP(A1,table,2,FALSE)) ...
確定! 回上一頁