[µo°Ý] ¥ÎSHEET ¦WºÙMATCH Àx¦s®æ¸ê®Æ

missbb

SHEET1¬O¥D­n¼Æ¾Ú
F5Àx¦s®æªº¤å¦r¸ê®Æ¬O  XX1100025 , CHAN TAI MAN , ³¯¤j¤å

¤u§@ªí2¦WºÙ¬OXX1100025
§Ú¥Î   ¡G¡@MATCH(MID(CELL("filename",A1),FIND("]",CELL("filename",A1),1)+1,31),Sheet1!F:F,0)¡@ªºµ²ªG¨S¦³¥X¨Ó¡H:Q

¤§«á·|¥Î¢×¢Ü¢Ò¢Ó¢æ+MATCH¥h§äSHEET1ªºF5Àx¦s®æ.

½Ð°Ý¿ù¦b¨º¸Ì?

¦³³Ò½ç±Ð.

missbb

¦^´_ 2# luhpro

¬O©ñ¤F XX1100025 , CHAN TAI MAN , ³¯¤j¤å


:)

missbb

¦^´_ 4# ML089

§Ú¥Î±z±Ð§Úªº°µ¨ì¤F¨ú¸ê®Æ:

=INDEX(Sheet1!$A:$Q,MATCH(MID(CELL("filename",$F$6),FIND("]",CELL("filename",$F$6),1)+1,31)&"*",Sheet1!$F:$F,),6)


¦ý¨ä¥L»P¦¹¤H¬ÛÃö¸ê®Æ, §Ú¥HOFFSET¨ú, ¦ý¿é¤J¤U¦C«o¦³¿ù, ½Ð«ü¾É!
OFFSET(ADDRESS(MATCH(MID(CELL("filename",$F$6),FIND("]",CELL("filename",$F$6),1)+1,31)&"*",Sheet1!$F:$F,),6,,,"Sheet1"),1,0,1,1)

missbb

¦^´_ 6# ML089

·PÁÂ!:lol