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鍒楀煎悓琛屽悎骞剁粨鏋滐纴绗浜屽垪涓篊鍒楀笺