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

[µo°Ý] VLOOKUP°ÝÃD½Ð±Ð

¦^´_ 1# rouber590324
  1. mymax = Application.WorksheetFunction.VLookup(M, Sheets("µ²ªG2").[A:Y], Z, False)
½Æ»s¥N½X
·P®¦ªº¤ß......(¦b³Â»¶®a±Ú°Q½×°Ï.¥Î¤ß¾Ç²ß·|¦³¶i¨Bªº)
¦ý¸ê·½µL­­,«á´©¦³­­,  ¤@¤Ñ1¤¸ªºÃÙ§U,¤H¤H¦³¯à¤O.

TOP

¦^´_ 7# rouber590324
µ²ªG2'!A:Y ³o½d³ò¬O³o¼Ë¶Ü?
  1. mymax = Application.WorksheetFunction.VLookup(M, Sheets("µ²ªG2").[A:A].Resize(, Y), Z, False)
½Æ»s¥N½X
·P®¦ªº¤ß......(¦b³Â»¶®a±Ú°Q½×°Ï.¥Î¤ß¾Ç²ß·|¦³¶i¨Bªº)
¦ý¸ê·½µL­­,«á´©¦³­­,  ¤@¤Ñ1¤¸ªºÃÙ§U,¤H¤H¦³¯à¤O.

TOP

¥»©«³Ì«á¥Ñ GBKEE ©ó 2015-3-26 11:47 ½s¿è

¦^´_ 9# rouber590324
¨q¥X    µLªk¨ú±oÃþ§O    WorksheetFunctionªºVLookupÄÝ©Ê.

³o²{¶H°Q½×°Ï¦³°Q½×¹L: (http://forum.twbts.com/viewthread.php?tid=10339)
·íApplication.WorksheetFunction.(¤u§@ªí¨ç¼Æ),¶Ç¦^¿ù»~­È®É,VBA·|¦³¿ù»~«H®§.
®³±¼WorksheetFunction¥i­×¥¿.
  1. mymax = Application.VLookup(M, Sheets("µ²ªG2").[A:A].Resize(, Y), Z, False)
½Æ»s¥N½X
·P®¦ªº¤ß......(¦b³Â»¶®a±Ú°Q½×°Ï.¥Î¤ß¾Ç²ß·|¦³¶i¨Bªº)
¦ý¸ê·½µL­­,«á´©¦³­­,  ¤@¤Ñ1¤¸ªºÃÙ§U,¤H¤H¦³¯à¤O.

TOP

        ÀR«ä¦Û¦b : ¸Ü¦h¤£¦p¸Ü¤Ö¡A¸Ü¤Ö¤£¦p¸Ü¦n¡C
ªð¦^¦Cªí ¤W¤@¥DÃD