For example: =IFERROR(VLOOKUP(B2,'Lookup table'!$A$2:$B$5, 2, FALSE), ""). Formula I'm using right now is: =IFERROR(VLOOKUP(G1;A1:B10;2 ...
確定! 回上一頁