进行匹配,并得到一个值(内行应该懂的)
SHEET3螺母和螺杆都是M3,如何让这个单元格识别是20呢?哪位好心的大师指点一下吧!
å ä¸ºè¡¨æ ¼ä¸çCååå¨ç¸åçæ°å¼ï¼æ¹æ³å°±æ¯æBåä¸Cåçéè¿è¿æ¥ç¬¦ & è¿æ¥èµ·æ¥ï¼æå 容å并ï¼è¿æ ·å°±è½åºåéå¤çæ°å¼äºã
æå ¬å¼æ¹ä¸ºè¿æ ·ï¼
=LOOKUP(1,0/(Sheet3!B$1:B$999&Sheet3!C$1:C$999=B1&C1),Sheet3!D$1:D$999)
æè ç¨è¿å ¬å¼ä¹è¡ï¼
=LOOKUP(1,0/((Sheet3!B$1:B$999=B1)*(Sheet3!C$1:C$999=C1)),Sheet3!D$1:D$999)
å¦æä¸å®åæè¦ç¨VLOOKUPå½æ°æ¥åçï¼åå ¬å¼å¦ä¸ï¼
=IF(C1="",0,VLOOKUP(B1&C1,IF({1,0},Sheet3!B$1:B$999&Sheet3!C$1:C$999,Sheet3!D$1:D$999),2,))
æææä»¶ä¼ ä¸æ¥ï¼è¯·ç¹å»è¿åçå³ä¸è§ç»¿è²çâç¹å»ä¸è½½âæé®ï¼ä¸è½½æ件ççææã