When VLOOKUP can't find a value in a lookup table, it returns the #N/A error. ... VLOOKUP inside an IF function that catches an error with ISNA or ISERROR.
確定! 回上一頁