由于您试图在找到 ColumnN 值的同一行中找到 ColumnL 值，因此我建议使用 INDEX MATCH 组合 - 类似于 VLOOKUP，但功能更强大(例如，可以向左看"，而 VLOOKUP 则不能).

Since you are trying to find the ColumnL value in the same row as you find the ColumnN value I’d suggest an INDEX MATCH combination – similar to VLOOKUP but more powerful (eg can ‘look to the left’, which VLOOKUP can’t).

=IFERROR(INDEX(L:L,MATCH(G2,N:N,0)),"") 

MATCH 查找在 ColumnN 中找到 G2 的 位置，以便它是您要返回的 ColumnL 值的行号.

MATCH looks for the position where G2 is found in ColumnN so that is the row number for the ColumnL value you want returned.