ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] ¨ç¼ÆVLOOKUP( ) ¤£ª¾¬°¦ó¥u¹ïÀ³¤@¦¸

[µo°Ý] ¨ç¼ÆVLOOKUP( ) ¤£ª¾¬°¦ó¥u¹ïÀ³¤@¦¸

§Ú¥ÎVLOOKUP¬d§ä¹ïÀ³¸ê®Æ ¥i¬O¤£ª¾¬°¦ó?¨Ò¦p
ªL¤f-(650kg¥H¤U) 0.5¾·   ¦bªí¤¤·|¦^³æ»ù­È 750
ªL¤f--(650~1000) 1.0¾·  
ªL¤f-(1000~1500) 1.5¾·
ªL¤f-(1500~2000) 2.0¾·
¦P¦a¦W²Ä¤G¶µ°_³æ»ù´N¤£¦^À³¤F? ½Ð¦U¦ì°ª¤â¬Ý¬Ý¬O§_¦³¸Ñ¨M¤è¦¡! ¤j¤ý³f¹BµP»ù.rar (22.78 KB)
¤T¤d¦~Ū¥v, ¤£¥~¥\¦W§Q¸S, ¤E¸U¨½®©¹D, ²×Âk¸Ö°s¥Ð¶é

¦^´_ 1# tomtracy
¥i¯à¬O²Å¸¹¡u~¡v¦b°µ¶Ã¡A§ó´«±¼¥¦§Y¥i¸Ñ¨M¡C
½Ð°Ñ¦Ò¡I

TOP

¦^´_ 1# tomtracy


=VLOOKUP(A8,CV,3,0)
·í¤å¦r¤º¦³ ~ ®ÉµLªk¬d¸ß(~¡B?¡B*³£¬O¯S®í²Å¸¹)¡A±N~§ï¬° ~~

=VLOOKUP(SUBSTITUTE(A8,"~","~~"),CV,3,0)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¥»©«³Ì«á¥Ñ JBY ©ó 2015-8-13 17:55 ½s¿è

¦^´_ 1# tomtracy

=VLOOKUP(SUBSTITUTE(A8,"~","?~"),CV,3,0)

=VLOOKUP(SUBSTITUTE(A8,"~","*~"),CV,3,0)

=VLOOKUP(SUBSTITUTE(A8,"~","~~"),CV,3,0)

TOP

¦^´_ 3# ML089


    ¥¿½T! ÁÂÁÂ
¤T¤d¦~Ū¥v, ¤£¥~¥\¦W§Q¸S, ¤E¸U¨½®©¹D, ²×Âk¸Ö°s¥Ð¶é

TOP

¦^´_ 4# JBY


    ÁÂÁ ³£¥¿½T
¤T¤d¦~Ū¥v, ¤£¥~¥\¦W§Q¸S, ¤E¸U¨½®©¹D, ²×Âk¸Ö°s¥Ð¶é

TOP

        ÀR«ä¦Û¦b : ª¾ÃÑ­n¥Î¤ßÅé·|¡A¤~¯àÅܦ¨¦Û¤vªº´¼¼z¡C
ªð¦^¦Cªí ¤W¤@¥DÃD