=IFERROR(VLOOKUP(E6, $A$6:$C$8, 3, FALSE), “Not Found”) ... Apply the same formula to the rest of the cells by dragging the lower right corner ...
確定! 回上一頁