ªð¦^¦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 : ¡i®É¤é²öªÅ¹L¡j¤@­Ó¤H¦b¥@¶¡°µ¤F¦h¤Ö¨Æ¡A´Nµ¥©ó¹Ø©R¦³¦hªø¡C¦]¦¹¥²¶·»P®É¶¡Ävª§¡A¤Á²ö¨Ï®É¤éªÅ¹L¡C
ªð¦^¦Cªí ¤W¤@¥DÃD