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

[µo°Ý] ¸ê®ÆÄæ¦ì¨Ã«D©T©w®É ¸Ó¦p¦ó­×§ï?

[µo°Ý] ¸ê®ÆÄæ¦ì¨Ã«D©T©w®É ¸Ó¦p¦ó­×§ï?

=IFERROR(LOOKUP(1,0/FIND(D$2:D$31,A2),D$2:D$31),"")
¤½¦¡¦p¤W
¦ýD$31¨Ã«D©T©w §Ú¸Ó¦p¦ó­×§ï
¦]¬°½d³ò¸ê®Æ¤j©óD$31®É
¦¹¤½¦¡´N·|Åã¥ÜªÅ¥Õ
ÁÂÁ¤j¤j
lo

        ÀR«ä¦Û¦b : ¤Hªº¤ß¦a¬O¤@²¥¥Ð¡A¤g¦a¨S¦³¼½¤U¦nºØ¤l¡A¤]ªø¤£¥X¦nªºªG¹ê¡C -
ªð¦^¦Cªí ¤W¤@¥DÃD