[µo°Ý] ÀH·N°Ñ·Ó¤§¹B¶O­pºâ

kai6929

¦U¦ì¤j®v­Ì¦n!
         ¯à§_½Ð±Ð¦p¦ó³]©w  ¦p:
E3:=­»´ä
E4=»O¥_¿¤®É
E6:·|=°Ï°ì¶O²vªº¬Û¹ï³æ»ù

¤U¸ü (38.16 KB)

2012-11-5 11:39

¤U¸ü (28.28 KB)

2012-11-5 11:39

KAI~22.rar (8.82 KB)

¤U¸ü¦¸¼Æ: 21

2012-11-5 11:39

Hsieh

¦^´_ 1# kai6929


    =INDEX(°Ï°ì¶O²v!B:H,MATCH(E4,°Ï°ì¶O²v!B:B,0),MATCH(E3,°Ï°ì¶O²v!3:3,0))

kai6929

ÁÂÁ¤F³o¦ì¤j®v,¥H¸Ñ¨M

c_c_lai

¦^´_  kai6929


    =INDEX(°Ï°ì¶O²v!B:H,MATCH(E4,°Ï°ì¶O²v!B:B,0),MATCH(E3,°Ï°ì¶O²v!3:3,0))
Hsieh µoªí©ó 2012-11-5 12:12

½Ð°Ý Hsieh ª©¤j¡A ¥H¤W±Ô­z¤§»yªk¦pªG¬O¨Ï¥Î VBA ¡A¨º»ò
¤£ª¾¸Ó¦p¦ó¼¶¼g¡H ÁÂÁ±z¡I

freeffly

¦^´_ 4# c_c_lai


    "=INDEX(°Ï°ì¶O²v!C[-3]:C[3],MATCH(R[-2]C,°Ï°ì¶O²v!C[-3],0),MATCH(R[-3]C,°Ï°ì¶O²v!R[-3],0))"
    ¬O­n³o¦U¶Ü

c_c_lai

¦^´_ 5# freeffly
¬Oªº¡I
¥H VBA »yªk¨¤«×À³¦p¦ó¼¶¼g¡H

c_c_lai

¦^´_ 5# freeffly
§Ú¸ÕµÛ¼g¤F¤@­Ó´ú¸Õ¼Ò²Õ¡A¦p¤U¡G

1. Sub Test()
   
2.     [D6] = Sheets("°Ï°ì¶O²v").[B3].Offset(WorksheetFunction.Match([C3], Sheets("°Ï°ì¶O²v").Range("B4:B28"), 0), _
   
3.                                              WorksheetFunction.Match([D3], Sheets("°Ï°ì¶O²v").Range("C3:H3"), 0))
   
4.     MsgBox Sheets("°Ï°ì¶O²v").[B3].Offset(WorksheetFunction.Match([C3], Sheets("°Ï°ì¶O²v").Range("B4:B28"), 0), _
   
5.                                      WorksheetFunction.Match([D3], Sheets("°Ï°ì¶O²v").Range("C3:H3"), 0)).Address
   
6. End Sub

½Æ»s¥N½X

¦³¨S¦³§ó¨Îªº¤è¦¡ªí¹F¡H

JBY

¦^´_ 1# kai6929

=INDEX(°Ï°ì¶O²v!B3:H100,MATCH(E4,°Ï°ì¶O²v!B3:B100,0),MATCH(E3,°Ï°ì¶O²v!B3:H3,0))

JBY

¦^´_ 1# kai6929

©ÎªÌ :

=VLOOKUP(E4,°Ï°ì¶O²v!B3:H100,MATCH(E3,°Ï°ì¶O²v!B3:H3,0),0)

c_c_lai

¦^´_ 9# JBY
¤£¦n·N«ä¡A§Ú¬O«ü¦pªG¨Ï¥Î VBA µ{¦¡»y¨¥¡A
¦³§_§ó¦nªºªí¹F¤è¦¡¡AÁÂÁ¡I