设a=5,b=7,c=8,d=8.5....我要的是当A1输入a时B1自动填充5,A1输入b时,B1自动填充7.....A列中输入a时对应的B列填充5
A1为æ¥æ¾æ¯å¯¹æ¡ä»¶ï¼B1为è¿åå¼ç»æãéç¨vlookupå½æ°å³å¯ã
è¡¨æ ¼åå æ ¼ä½ç½®å¦å¾ï¼a8:ac11为已ç¥æ¡ä»¶
å¨B1ä¸è¾å ¥å ¬å¼ï¼=VLOOKUP(A1,A8:C11,3,0)ã
ç¶åå¨A1è¾å ¥ç¸åºçåæ¯a b c d å¾å°æ³è¦ççæ¡ã