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

½Ð°ÝVLOOKUP ¦^¶Ç¸ê®Æ°ÝÃD

½Ð°ÝVLOOKUP ¦^¶Ç¸ê®Æ°ÝÃD

§Ú¼gªºVLOOKUP ¦^¶Ç¸ê®Æ¦³»~
¥i§_À°¦£¸Ñµª Book2.rar (63.08 KB)

¦^´_ 1# yan2463
J3=VLOOKUP(TEXT(B$3,0)&"*",³sÄò¶R½æ!A:K,6,1)

TOP

ÁÂÁÂ,¤w¥i¥H¨Ï¥Î¤F

TOP

¦^´_ 3# yan2463

¥t¦A½Ð°Ý­Y§Ú¦³­ÓÄæ¦ì,­n¦^¶Ç¤T­Ó¸ê°T
¤T­Ó¬°¿W¥ß¸ê®Æ,­Y¦³­t¼Æ,¿W¥ß¬°¬õ¦â
¦pªþ¥ó Book2.rar (62.85 KB)

TOP

        ÀR«ä¦Û¦b : ¥@¤W¦³¨â¥ó¨Æ¤£¯àµ¥¡G¤@¡B§µ¶¶ ¤G¡B¦æµ½¡C
ªð¦^¦Cªí ¤W¤@¥DÃD