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

¨ú¥XÃöÁä¦r¨ÃÅã¥Ü¤Î¦C¥X«DÃöÁä¦r¥H¥~¦r¦ê

¦^´_ 1# leiru

D:D ÃöÁä¦r¡A©ñªº¶¶§Ç­n¦r¦hªº±Æ¦C¦b«á­±

    ¥x»È±b¸¹
    ¥x»È±b¸¹-Áp«H
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

B2
=IFERROR(LOOKUP(,-SEARCH("*"&D$2:D$9,A2),D$2:D$9),"")

¤]¥i¥H¦p¤U
=IFERROR(LOOKUP(,-FIND(D$2:D$9,A2),D$2:D$9),"")
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 1# leiru

¦pªG ÃöÁä¦r µLªk¨Ì·Óªøµu±Æ§Ç®É

=INDEX(D:D,MOD(MAX(ISNUMBER(FIND(D$2:D$39,A2))*LEN(D$2:D$39)*100+ROW($2:$39)),100))&""

°}¦C¤½¦¡(¤TÁä¿é¤J)
   
ª`·N! $39 »Ý­n½Õ¾ã¦Ü¤Ö³Ì«á¤@®æ»Ý­n¬OªÅ®æ
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : ¡i»X½ªªº¦Û¥Ñ¡j¤H±`¦b¤°»ò³£¥i¥H¦Û¥Ñ¦Û¦bªº®É­Ô¡A«o³Q³oºØÀH¤ß©Ò±ýªº¦Û¥Ñ»X½ª¡AµêÂY®É¥ú¦Ó²@µLıª¾¡C
ªð¦^¦Cªí ¤W¤@¥DÃD