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

VLOOKUP¤Ï¦V¦^¶Ç°ÝÃD

VLOOKUP¤Ï¦V¦^¶Ç°ÝÃD

VLOOKUP¥i¦^¶Ç·j´M¨ì²Å¦X¸ê®Æ½d³ò¥k°¼¼Æ­È¡A¦ý¦pªG»Ý¦^¶Ç¥ª°¼¼Æ­È®É¸Ó¥Î¦ó¤½¦¡?
¦pªþÀÉH1¤½¦¡¸Ó¦p¦ó¼g?

¤Ï¦VVLOOKUP.rar (1.43 KB)

¦^´_ 1# loyyee


    =LOOKUP(2,1/($C$2:$C$4=G1),$A$2:$A$4)

TOP

¦^´_ 2# register313

¥i¥H¤F¡A·PÁ±z!

TOP

        ÀR«ä¦Û¦b : ­×¦æ­nô½t­×¤ß¡AÂǨƽm¤ß¡AÀH³B¾i¤ß¡C
ªð¦^¦Cªí ¤W¤@¥DÃD