Hsieh

¦^´_ 1# kai6929


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

Hsieh

¦^´_ 7# c_c_lai
§Q¥ÎSheet1ªº¨Æ¥óµ{§Ç

1. Private Sub Worksheet_Change(ByVal Target As Range)
   
2. With Me
   
3. If Intersect(Target, .[E3:E4]) Is Nothing Then Exit Sub
   
4.   a = .[E3]
   
5.   b = .[E4]
   
6.   With Sheet2
   
7.     c = .Range("B3").CurrentRegion.Find(a, lookat:=xlWhole).Column
   
8.     r = .Range("B3").CurrentRegion.Find(b, lookat:=xlWhole).Row
   
9.     MsgBox .Cells(r, c)
   
10.   End With
    
11. End With
    
12. End Sub

½Æ»s¥N½X

Hsieh

¦^´_ 21# aer

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

½Æ»s¥N½X

½d³òÀ³¸Ó±qAÄæ¶}©l¤~¹ï¡A¦hÁ«ü¥¿!