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

[µo°Ý] ½Ð°Ý~~HLookup»PVLookup ¦³©Ò¤£¦P¶Ü?

[µo°Ý] ½Ð°Ý~~HLookup»PVLookup ¦³©Ò¤£¦P¶Ü?

Sub Macro1()

Dim y As String
Dim z As String

z = 2
y = Worksheets("±Æµ{").Range("F" & z).Value
   Range("F3").Value = Application.HLookup("y", Sheet3.[e2:AZ39], 2, 0)

End Sub

³o¼Ë·|Åã¥Ü#N/A¡A¦ý¦pªG¨Ï¥ÎVLookup½T¬O¥i¥H
¬O¨ºùØ¿ù»~¤F= =
ÁÂÁÂ

¦pªG¨Ï¥ÎVLookup½T¬O¥i¥H
¨º¥ÎHLookup¦ÛµM¤£¹ï¤F¡C
½Ð¥ý§ËÀ´¨â­Ó¨ç¼Æ®t§Oªº¦a¤è¡C

TOP

¥»©«³Ì«á¥Ñ kimbal ©ó 2012-5-12 21:15 ½s¿è

²³æ¨Ó»¡, H/V¬O«ü¹ï¹ï¸Iªº¤è¦V
HLOOKUP¬O¾î¦V(Äæ:A,B,C,D,E....)
VLOOKUP¬Oª½¦V(¦æ:1,2,3,4,5...)
(¦Ó²Ä3­Ó¨ç¼ÆLOOKUPªº¹w³]¬Oª½¦V)

¥i¥H°Ñ¦Ò³o¸Ì½d¨Ò
http://office.microsoft.com/zh-tw/excel-help/HP005209114.aspx
http://office.microsoft.com/zh-tw/excel-help/HP005209335.aspx
À´±oµo°Ý,µª®×´N·|¦b¨ä¤¤

¤µ¤éの¤@¬íは  ©ú¤éにない
http://kimbalko-chi.blogspot.com
http://kimbalko.blogspot.com

TOP

§Úª¾¹D¤@­Ó¬Oª½¦V¡B¤@­Ó¬O¾î¦V
¦ý¥¨¶°¤£¯à¤]³o¼Ë¼g¶Ü
½Ð¤j¤j¥i¥HÀ°§Ú¶Ü??

TOP

¥i¥H³o¼Ë¼g§r¡A­º¥ý©pªº¸ê®Æ±Æ©ñ­n¾A¥Î³o­Ó¨ç¼Æ
¦A¨ÓÅܼƤ£¯à¥[Âù¤Þ¸¹¡A©pªº"y"¥[Âù¤Þ¸¹´NÅܦ¨¬O"y"³o­Ó¦r²Å¦Ó¤£¬OÅܼƤF¡C

TOP

¦^´_ 5# oobird

Âù¤Þ¸¹¨ú®ø±¼ÁÙ¬O¤@¼ËÅã¥ÜNA"

TOP

¦^´_ 6# ÅQ®ð¨«¥þ¨­

¤]¦³¥i¯à¬OÀx¦s®æªº°ÝÃD
1.  Range("F" & z)»PSheet3.[e2:AZ39] ®æ¦¡¤£¦P(¦p¼Æ¦r»P¤å¦r®æ¦¡)
2.  Range("F" & z)»PSheet3.[e2:AZ39] ¤º¦³ªÅ¥Õ¤å¦r
.....
¤W¶ÇÀÉ®×

TOP

Åã¥ÜNA"ªí¥Ü§ä¤£¨ì¯Á¤Þ
½d³ò¤¤¨S¦³©p­n§äªºªF¦è
Sheet3.[e2:AZ39]ªº²Ä¤@¦C(E2:AZ2)½d³ò¥²¶·­n¦³ Worksheets("±Æµ{").Range("F" & z).Value
³o­Ó¤½¦¡¤~¯à¥Î

TOP

¦^´_ 7# register313


    123.rar (12.53 KB)
½Ð§A¬d¬Ý^^

TOP

¦^´_ 9# ÅQ®ð¨«¥þ¨­
  1. Sub Macro1()
  2.   Range("F3") = Application.HLookup(Range("F2"), Sheet3.[E2:AZ39], 2, 0)
  3. End Sub
½Æ»s¥N½X

TOP

        ÀR«ä¦Û¦b : ¦³®É·í«äµL®É­W¡A¦n¤Ñ­n¿n«B¨Ó³¡C
ªð¦^¦Cªí ¤W¤@¥DÃD