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

½Ð°ÝLOOKUP¦³¶i¶¥ª©¶Ü?

G2

=LOOKUP(2,1/FIND({"¥®¨à¶é","°ê¤p","°ê¤¤","°ª¤¤","¾Ç°|","Å@®Õ","¤j¾Ç"},D2),{1,2,3,4,5,5,5})
300 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

¤í¯Ê¦Ò¼{ªÅ¥Õ
¸É¤W

G2

=LOOKUP(,-FIND({"","¥®¨à¶é","°ê¤p","°ê¤¤","°ª¤¤","¾Ç°|","Å@®Õ","¤j¾Ç"},D2),{"",1,2,3,4,5,5,5})
300 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

        ÀR«ä¦Û¦b : ¯àµ½¥Î®É¶¡ªº¤H¡A¥²¯à´x´¤¦Û¤v§V¤Oªº¤è¦V¡C
ªð¦^¦Cªí ¤W¤@¥DÃD