第1个回答 2018-11-02
从第二列A:A改成A2,
让公式保持
=VLOOKUP(A2,[成功.xlsx]sheet1!$A$1:$D$100),4,0)
=VLOOKUP(A3,[成功.xlsx]sheet1!$A$1:$D$100),4,0)
=VLOOKUP(A4,[成功.xlsx]sheet1!$A$1:$D$100),4,0)
……
=VLOOKUP(A100,[成功.xlsx]sheet1!$A$1:$D$100),4,0)
Sheet1!$A$1:$D$100自己根据实际设定即可。