æ ¹æ®å
³é®åï¼è·¨è¡¨å¼ç¨ï¼å¯ä»¥ç¨vlookupå½æ°æ¥å®ç°ã
表ä¸ç¤ºä¾æ°æ®ï¼
å¦ä¸å¾ï¼å¨åå·¥èµè¡¨æ¶ï¼éè¦æåºç¡èµæ表ï¼å示å§åãèå¡ãåºèªçåºç¡ä¿¡æ¯ã
åå¦å¨è¡¨äºä¸ï¼ç¨å§åä½ä¸ºå
³é®åï¼å¯ä»¥å¦ä¸å¾æ示ï¼
B2å
¬å¼ä¸ºï¼=VLOOKUP($A$2,Sheet1!$A$2:$D$8,COLUMN(B:B),0)
C2å
¬å¼ä¸ºï¼=VLOOKUP($A$2,Sheet1!$A$2:$D$8,COLUMN(C:C),0)
D2å
¬å¼ä¸ºï¼=VLOOKUP($A$2,Sheet1!$A$2:$D$8,COLUMN(D:D),0)
该å½æ°ä»¥å§åä½ä¸ºå
³é®åï¼å¨è¡¨ä¸$A$2:$D$8åºåä¸æ¥æ¾ï¼ç¶ååå«è¿å该åºåç第2ã3ã4åï¼å¹¶ç²¾ç¡®å¹é
ãå
¶ä¸
COLUMNå½æ°ç¨æ¥çæ该å½æ°ç第ä¸åæ°ï¼å¼ç¨æ¹å¼ä¸ºç¸å¯¹å¼ç¨ï¼åå³æå¨å
¬å¼æ¶ï¼å¯ä»¥èªå¨æ¹ååæ°æ°å¼ã