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

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

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

[ª©¥DºÞ²z¯d¨¥]
  • Hsieh(2013-11-27 14:43): ½Ðªþ¤WÀÉ®×

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

¦³³Ò½ç±Ð.

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¥¿±`§ä¨ìªº³á.

TOP

¦^´_ 2# luhpro

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


:)

TOP

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

=MATCH(MID(CELL("filename",A1),FIND("]",CELL("filename",A1),1)+1,31)&"*",Sheet1!F:F,)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 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)

TOP

¦^´_ 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,)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 6# ML089

·PÁÂ!:lol

TOP

        ÀR«ä¦Û¦b : ¡i¦æµ½­n¤Î®É¡j¦æµ½­n¤Î®É¡A¥\¼w­n«ùÄò¡C¦p¿N¶}¤ô¤@¯ë¡A¥¼¿N¶}¤§«e¤d¸U¤£­n°±º¶¤õ­Ô¡A§_«h­«¨Ó´N¤Ó¶O¨Æ¤F¡C
ªð¦^¦Cªí ¤W¤@¥DÃD