可以写入公式,如变量在A1,可写成:=VLOOKUP(RC[2],CHOOSE({1,2},INDIRECT(A1&"!R1C4:R7000C4"),INDIRECT(A1&"!R1C1:R7000C1")),2,FALSE)
可写成:=VLOOKUP(RC[2],CHOOSE({1,2},INDIRECT(A1&"!R1C4:R7000C4"),INDIRECT(A1&"!R1C1:R7000C1")),2,FALSE)