è¿æ¯ä¸ä¸ªååæ¥æ¾çé®é¢ï¼ä¸é¢ä¸¾ä¾è¯´æå ç§æ¹æ³ï¼
ä¾ï¼å¦ä¸å¾æ示ï¼æ ¹æ®Båå§åæ¥æ¾Aåçåå·¥å·ãéæ¥æ¾çå§åå¨D2åå æ ¼ã
ä¸é¢ä»ç»å ç§å½æ°æ¹æ³ï¼
1ãéè¿IFæ°ç»å ¬å¼æ建VLOOKUPæ¥æ¾åºåï¼å®ç°AãBå对è°ã=VLOOKUP(D2,IF({1,0},B2:B9,A2:A9),2,0)
2ãéè¿CHOOSEæ°ç»å ¬å¼æ建VLOOKUPæ¥æ¾åºåï¼å®ç°AãBå对è°ã=VLOOKUP(D3,IF({1,0},B$2:B$9,A$2:A$9),2,0)
3ãINDEXåMATCHå½æ°ç»å使ç¨ã=INDEX(A2:A9,MATCH(D2,B2:B9,0))
4ãOFFSETåMATCHå½æ°ç»å使ç¨ã=OFFSET(A1,MATCH(D2,B2:B9,0),0)