æä¾è¯¦ç»çåæ°å举ä¾è¯´æ
Excelçæ¬åèï¼2010
1ãåè½ï¼è¿åè¡¨æ ¼æåºåä¸çå¼æå¼çå¼ç¨
2ãè¯æ³ï¼INDEX(array, row_num, [column_num])
3ãåæ°è¯´æï¼
Array å¿ éãåå æ ¼åºåææ°ç»å¸¸éã
å¦ææ°ç»åªå å«ä¸è¡æä¸åï¼åç¸å¯¹åºçåæ° row_num æ column_num 为å¯éåæ°ã
å¦ææ°ç»æå¤è¡åå¤åï¼ä½åªä½¿ç¨ row_num æ column_numï¼å½æ° INDEX
è¿åæ°ç»ä¸çæ´è¡ææ´åï¼ä¸è¿åå¼ä¹ä¸ºæ°ç»ã
Row_num å¿ éãéæ©æ°ç»ä¸çæè¡ï¼å½æ°ä»è¯¥è¡è¿åæ°å¼ãå¦æçç¥ row_numï¼åå¿ é¡»æ
column_numã
Column_num å¯éãéæ©æ°ç»ä¸çæåï¼å½æ°ä»è¯¥åè¿åæ°å¼ãå¦æçç¥
column_numï¼åå¿
é¡»æ row_numã
4ã举ä¾è¯´æï¼