C3åC13å
¬å¼ä¸è´
æ¯è¿ç§ä¸é¡µå¯ä»¥æå°ä¸¤å¼ æ ¸æ¥è¡¨ï¼ææ³å¨æ ¸æ¥è¡¨C3å¼ç¨æ±æ»è¡¨B5æ¶ï¼æ ¸æ¥è¡¨C13èªå¨å¼ç¨æ±æ»è¡¨B6ï¼ææå°±æ¯å½æC3å¼ç¨æ±æ»è¡¨Bï¼xï¼æ¶ï¼C13èªå¨å¼ç¨æ±æ»è¡¨B(x+1)ç模å¼ï¼å¯ä»¥åå°å大ç¥
C13å
¬å¼
=IF(C3="","",Sheet2!B6))
å¦æC3çäºSHEET2 B5,C13èªå¨å¡«å sheet2 Bï¼5+1ï¼ãå¦æC3çäºSHEET2 B6,C13èªå¨å¡«å sheet2 Bï¼6+1ï¼ã
追çC13å
¬å¼,表äºBåæéå¤å¼åæ
åµå¯è½åºé
=IF(C3="","",OFFSET(Sheet2!B1,MATCH(C3,Sheet2!B:B,),))