excel 发表于 2020-01-10 更新于 2020-09-11 1. 比对 2 列 V2 -> V1 =IFERROR(VLOOKUP(A4,$J4:4:4:J$19,1,FALSE),"") V1 -> V2 =IFERROR(VLOOKUP(J4,$A4:4:4:A$19,1,FALSE),"")