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

IFªº¥Îªk°ÝÃD

¦^´_ 1# kkooo15


=LOOKUP(,0/(C2:I2="¡½"),D2:J2)

LOOKUP(,0/(N2:R2="¡½"),O2:S2)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : ¦³Ä@©ñ¦b¤ß¸Ì¡A¨S¦³¨­Åé¤O¦æ¡A¥¿¦p¯Ñ¥Ð¤£¼½ºØ¡A¬Ò¬OªÅ¹L¦]½t¡C
ªð¦^¦Cªí ¤W¤@¥DÃD