=IFERROR(VLOOKUP("d",B5:C7,2,FALSE),"CHECK"). Result in cell D5 (CHECK) - returns the specified value (CHECK) given that the formula in the IFERROR function ...
確定! 回上一頁