A. Excel 鎬庢牱鐢╒LOOKUP鍖歸厤澶氬垪鏁版嵁錛
1銆佸崟涓鏉′歡鍖歸厤鏌ユ壘澶氬垪鏁版嵁銆
紺轟緥鍏寮忥細
=VLOOKUP($A1,SHEET2!$A$1:$D$100,COLUMN(A1),)
鍙蟲媺濉鍏3鍒楋紝鍐嶄笅鎷夊～鍏呫傚叕寮忛氳繃A鍒楁暟鎹鍖歸厤鍚庯紝鍙寰楀埌B鍒桟鍒楀拰D鍒楃殑鏁版嵁銆
2銆佸氬垪鏉′歡鍖歸厤鏌ユ壘絎﹀悎鏉′歡鏁版嵁銆
紺轟緥鍏寮忥細
=VLOOKUP(A1&B1,IF({1,0},SHEET2!A$1:A$100&SHEET2!B$1:B$100,SHEET2!C$1:C$100),2,)
鍏朵腑錛欼F({1,0},SHEET2!A$1:A$100&SHEET2!B$1:B$100,SHEET2!C$1:C$100)寤虹珛涓涓鍖呭惈涓ゅ垪鏁版嵁鐨勫唴鍦ㄦ暟緇勶紝絎涓鍒椾負A鍒椾笌B鍒楀煎悓琛屽悎騫剁粨鏋滐紝絎浜屽垪涓篊鍒楀箋