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

[µo°Ý] ¨Ì¾Úsheet¦WºÙ§ì¨ú¸ê®Æ

[µo°Ý] ¨Ì¾Úsheet¦WºÙ§ì¨ú¸ê®Æ

½Ð°Ý¦bÁ`ªí¤W³]©w¦n¸ê®Æ¦p¤U¹Ï¡A

·Q¦b¤U¤@­Ó¤u§@ªí¤¤¡A¨Ì¤u§@ªíªº¦WºÙ僀¤J¬ÛÃö¸ê®Æ¡A¦p¤U¹Ï
¦ý±a¤£¥X¨Ó¡A½Ð°Ý¸Ó«ç»ò°µ©O¡H

¥t¡A­Y¯à±a¥X¸ê®Æªº¸Ü¡A¬O§_¥i²¤Æ¤½¦¡¦¨¦p¤U©O¡H
VLOOKUP(RIGHT(CELL("filename"),LEN(CELL("filename"))-FIND("]",CELL("filename"))),Á`ªí!A:B,2,0)

ÁÂÁ¡C

Á`ªíAÄæ¼Æ¦rÄÝ"¼Æ­È"®æ¦¡, CELL§ì¥X¨Óªº¬O"¤å¦r'®æ¦¡, VLOOKUP·íµM°t¤£¤W,
=VLOOKUP(--RIGHT(SUBSTITUTE(CELL("filename",A1),"]",REPT(" ",99)),99),Á`ªí!A:B,2,)
=VLOOKUP(--MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,99),Á`ªí!A:B,2,)

¨â­Ó--­t¸¹Âà¼Æ­È~~
========================================
¥t¥~:
CELL("filename",A1) , ¨ºA1¾¨¶q¤£­n¬Ù²¤

TOP

¦^´_ 2# ­ã´£³¡ªL
¤F¸Ñ¡AÁÂÁ¨ó§U¡C:)

TOP

        ÀR«ä¦Û¦b : ºw¤ô¦¨ªe¡C²É¦Ì¦¨ÅÚ¡A¤Å»´¤vÆF¡A¤Å¥Hµ½¤p¦Ó¤£¬°¡C
ªð¦^¦Cªí ¤W¤@¥DÃD