使ç¨å ¬å¼ãå ¬å¼ä¸º=IF(ISERROR(LOOKUP(1,0/((ç»ç®è¡¨!$B$3:$B$1000=B3)*(ç»ç®è¡¨!$N$3:$N$1000=N3)*(ç»ç®è¡¨!$R$3:$R$1000=S3)),S3:S1000)),0,(LOOKUP(1,0/((ç»ç®è¡¨!$B$3:$B$1000=B3)*(ç»ç®è¡¨!$N$3:$N$1000=N3)*(ç»ç®è¡¨!$R$3:$R$1000=S3)),S3:S1000)))以ä¸ç¨âCTRL+SHIFT+ENTERâç»æ
ä¾ï¼B3ãN3ãS3å¨å½åè¡¨æ ¼ä¸ï¼ç»ç®è¡¨ä¸ºå¦ä¸ä¸ªè¡¨æ ¼å ¬å¼è§£éï¼å½B3=âç»ç®è¡¨!$B$3:$B$1000âèå´å æ°å¼ï¼å¹¶N3=âç»ç®è¡¨!$N$3:$N$1000âèå´æ°å¼ï¼å¹¶S3=âç»ç®è¡¨!$R$3:$R$1000âèå´æ°å¼æ¶æ¾ç¤ºæ»¡è¶³ä¸ä¸ªæ°æ®æ对åºç第å个æ°å¼å¹¶æ¾ç¤ºå¨S3:S1000对åºè¡ä¸ï¼å¦åæ¾ç¤ºâ0âã
使ç¨æ åµï¼ä¸¤ä¸ªè¡¨æ°æ®é½ä¸æ ·ï¼ä½æ°æ®è¡ä½ç½®ä¸ä¸æ ·çæ åµä¸ï¼å¹¶ä¸è¿è¦æ ¹æ®åä¸ä¸ªæ°æ®æ·»ç¬¬å个æ°æ®çæ åµä¸ä½¿ç¨ã
注æå ¬å¼ä¸ç符å·åå°æ¬å·é½è¦ä¸ä¸å¯¹åºã
有什么函数可以实现吗?