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

[µo°Ý] ½ÐÀ°¦£¬Ý¤@¤U°Ñ¼Æ¨ºùا˿ù

[µo°Ý] ½ÐÀ°¦£¬Ý¤@¤U°Ñ¼Æ¨ºùا˿ù

½Ð¦U¦ì¤j¤jÀ°§Ú¤@¤U
§Ú¨ºÃä°Ñ¼Æ§Ë¿ù
¨S¿ìªkŪ¨ú¸ê®Æ
Sheet1    LÄæ¦ì
=IF(ISERROR(VLOOKUP("*"&F2&"*",Sheet2!#REF!,4,)),0,TEXT(VLOOKUP("*"&F2&"*",Sheet2!#REF!,4,)/100,"0.00%"))
­nŪ¨úSheet2 DÄæ¦ì¼Æ­È

ªÑ.rar (36.4 KB)

slip

ÃC¦âMARKªºµ{¦¡¥¿½T¶Ü??

=IF(ISERROR(VLOOKUP("*"&F2&"*",Sheet2!#REF!,4,)),0,TEXT(VLOOKUP("*"&F2&"*",Sheet2!#REF!,4,)/100,"0.00%"))

TOP

¦^´_ 1# slip

§AÀ³¸Ó¬O­n°Ñ·Ó¨ìA:FÄæ¦ì¡A·í§A§¹¦¨¤½¦¡«á¡A¤S§R°£¤F¨ä¤¤¬Y¨ÇÀx¦s®æ´N·|²£¥Í¿ù»~°Ñ·Ó¡A¬Ý¬Ý¬O§_§A­nªº?
=IF(ISERROR(VLOOKUP("*"&F2&"*",Sheet2!A:F,4,)),0,TEXT(VLOOKUP("*"&F2&"*",Sheet2!A:F,4,)/100,"0.00%"))
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

ÁÂÁÂ Hsieh
¬O§Ú­nªº
ÁÂÁÂ
slip

TOP

        ÀR«ä¦Û¦b : ¸Ü¦h¤£¦p¸Ü¤Ö¡A¸Ü¤Ö¤£¦p¸Ü¦n¡C
ªð¦^¦Cªí ¤W¤@¥DÃD