lookup()ç¨ä¸æ¬å·âï½ï½âå¼ç¨æ°æ®ï¼åªè½å¼ç¨ææ¬ï¼å¯ä»¥å移å½æ°offset()åæ°ã
é¦å å½å ¥ææç¹ä½ï¼
ç¶åç¨å ¬å¼ç´æ¥å¾åºææã
å ¬å¼=LOOKUP(ROUND(B2,0),OFFSET(ææç¹ä½!$A$1,MATCH(A2,ææç¹ä½!A:A,0)-1,1,1,3),{0,0.002,0.004})