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

[µo°Ý] Vlookup°Ñ·ÓÀÉ¥iÀH¤é´ÁÅܧó¶Ü¡H

[µo°Ý] Vlookup°Ñ·ÓÀÉ¥iÀH¤é´ÁÅܧó¶Ü¡H

¦U¦ì¥ý¶i¡A±ý¨Ï¥Îvlookup¬d§ä¸ê®Æ¡A
¦ý°Ñ·ÓÀÉ®×ÀɦW·|ÀH¤é´ÁÅܧó¡A¦p¹Ï¬õ®Ø³B¡A
¬O§_¦³¿ìªkÅý¥¦¦Û°ÊÀHÀɮפé´ÁÅܧó?

vlookup

10E68052.gif
2018-5-16 11:14

¥»©«³Ì«á¥Ñ nolookyou ©ó 2018-5-16 11:56 ½s¿è

¦^´_ 1# marionlongly


    ¥i¥H¡A§ï¦¨¥ÎVBA¼g¡A¦b¥´¶}¤u§@ªí®ÉªºWorkbook_Open()°Ï¬q¡A¥ÎVBA¼g¤J¤½¦¡¡A¤é´Á³¡¤À¥ÎÅܼƨú·í¤Ñ¤é´Á§Y¥i~

TOP

¦^´_ 2# nolookyou

nolookyou ¤j¤j¡A
½Ð°Ývba«ü¥O¸Ó¦p¦ó¼¶¼g©O¡H
¦]¬°¹ïvbaªº»â°ì§¹¥þ¤£¤F¸Ñ¡A
·PÁ§A~

TOP

¦^´_ 3# marionlongly


    ¥ý¬Ý¤@¤U¼v¤ù
    ¬Ý³o¬O¤£¬O§A­nªºµ²ªG
    0516-1.rar (1019.2 KB)

TOP

¦^´_ 3# marionlongly


    ³á!!¬Ý¨ìª©¤j¹ïVBA¤£¤F¸Ñ¡A¨º´N¤£¥ÎVBA¡A¥Î¯Â¤½¦¡¤]¥i¥H¸Ñ¡A
    ¦bA1Àx¦s®æ´¡¤J¥H¤U¤½¦¡§Y¥i¹F¨ì§Ú¤W­±¼v¤ù¤º¥ÎVBAªº®ÄªG¡A
   
    ´£¿ô¤@¤U´N¬O¡A¸óÀÉ®×°µVLOOKUP®É¡A2­ÓÀɮ׳£­n¶}µÛ³á!!
    ½Ðª©¤j´ú¸Õ¤@¤U¡G

    =IF(H4=0,"",VLOOKUP(H4, INDIRECT("'C:\ABC\DEF\GHI\JKL\[MNO"&TEXT(TODAY(),"mmdd")&".xlsx]´ú¸Õ'!$M:$AR"), 32, 0))

TOP

¦^´_ 5# nolookyou


    ·PÁ¤À¨É

TOP

        ÀR«ä¦Û¦b : §g¤l¦p¤ô¡AÀH¤è´N¶ê¡AµL³B¤£¦Û¦b¡C
ªð¦^¦Cªí ¤W¤@¥DÃD