0%

excel

1. 比对 2 列

V2 -> V1
=IFERROR(VLOOKUP(A4,$J4:4:J$19,1,FALSE),"")

V1 -> V2
=IFERROR(VLOOKUP(J4,$A4:4:A$19,1,FALSE),"")