[µ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¨º¸Ì?

¦³³Ò½ç±Ð.

luhpro

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

¤u§@ªí2¦WºÙ¬OXX1100025
...
missbb µoªí©ó 2013-11-27 13:06

§A F5 Àx¦s®æ¥u¦³©ñ XX1100025 ¶Ü?
ÁÙ¬O©ñ¤F XX1100025 , CHAN TAI MAN , ³¯¤j¤å ?
§Ú¸Õ¹L¦pªG¥u¦³©ñ XX1100025 ¬O¥i¥H¥¿±`§ä¨ìªº³á.

missbb

¦^´_ 2# luhpro

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


:)

ML089

¤½¦¡¤¤¥[ &"*" ¤~¯à§@ °_ÀY³¡¤À¬d¸ß

=MATCH(MID(CELL("filename",A1),FIND("]",CELL("filename",A1),1)+1,31)&"*",Sheet1!F:F,)

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)

ML089

¦^´_ 5# missbb

>>¦ý¨ä¥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)
    OFFSET¨ç¼Æ¨Ï¥Î¤è¦¡¿ù»~


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

missbb

¦^´_ 6# ML089

·PÁÂ!:lol