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

½Ð±Ð Exceel ¨ç¼ÆÂন VBA ­n¦p¦ó¼g©O¡H

½Ð±Ð Exceel ¨ç¼ÆÂন VBA ­n¦p¦ó¼g©O¡H

¥»©«³Ì«á¥Ñ yangtest ©ó 2011-12-6 11:55 ½s¿è


½Ð±Ð¦U¦ì·s¶i¡G

©³¤Uªº  Exceel ¨ç¼ÆÂন VBA ­n¦p¦ó¼g©O¡H

1.  VLOOKUP($K$4,INDIRECT(LEFT($K$4,1)&"!$E$2:$L$4000"),8,0))

2.  ¨ú±o 1. VLOOKUP ©Ò»`´M¨ì¤§Àx¦s®æ¦ì¸m(¥]§tÄæ»P¦C)

= WorksheetFunction.VLookup([K4], Sheets(Left([K4], 1)).Range("E2 : L4000"), 8, 0)
My Blog
http://blog.xuite.net/a8350070

TOP

¦^´_ 2# a8350070
·PÁ±zªº«ü¾É¡A¾Ç²ß¤F¡AÁÂÁ ¡I¡I

TOP

        ÀR«ä¦Û¦b : ¬Ý§O¤H¤£¶¶²´¡A¬O¦Û¤v­×¾i¤£°÷¡C
ªð¦^¦Cªí ¤W¤@¥DÃD