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

[µo°Ý] excel °Ñ·Ó

¦^´_ 1# shenghuei

I2 =LOOKUP(,0/((A$2:A$99=F2)*(B$2:B$99=G2)*(C$2:C$99=H2)), D$2:D$99)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : µoµÊ®ð¬Oµu¼ÈªºµoºÆ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD