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

¤@­ÓVLOOKUP¨ç¼Æ°ÝÃD

¤@­ÓVLOOKUP¨ç¼Æ°ÝÃD

¤j¤j­Ì, ¦w¦n
¦³¤@VLOOKUP°ÝÃD½Ð±Ð,²{§âªþ¥ó¤W¶Ç, ½Ð¤j¤j­Ì±Ð¾É, ÁÂÁÂ!!
Book1.rar (8.71 KB)

¦^´_ 1# 317

¥ý¥Î¨ç¼Æ¨Ó§¹¦¨,°Ñ¦Ò

1.¿ïC4~C13
  ¿é¤J=TRANSPOSE(OFFSET(Sheet1!B3:K3,MATCH(C3,Sheet1!A3:A18,0)-1,0))
   Ctrl+Shift+Enter §¹¦¨¿é¤J
2.C14=VLOOKUP(C3,Sheet1!A3:M18,12,0)&VLOOKUP(C3,Sheet1!A3:M18,13,0)

transpose.rar (6.52 KB)

TOP

¦^´_ 2# register313
ÁÂÁ¤j¤j¦^À³, ¨ä¹ê§Ú²{®É¤§Àɮפ]¬O¨ç¼Æ§¹¦¨, ¨ç¼ÆÁö¤£¬O¦P¤@¦ý¥\®Ä»P¤j¤jªº¤@¼Ë, ¦ý¯u¤ß·PÁ¤j¤j,
¦]Àɮצ³®Éµ¹¤©¨ä¥L¦P¨Æ¨Ï¥Î, ©¹©¹°µ¦¨, ¤u§@ªí¨ç¼Æ·lÃa, ¦Ó¦P¨Æ¥ç¤£©ú¥Õ­ì²z, ¬G§Æ±æ¯à¥Îµ{¦¡¨ú¥N, ¦]µ{¦¡¬O¦bµ{¦¡°Ï, ¬O¤£·|¨ü¨ì·lÃa,¬G½Ð¤j¤j­Ì¨ó§U, ÁÂÁÂ!!

TOP

¦^´_ 3# 317
  1. Private Sub Worksheet_Change(ByVal Target As Range)
  2. Dim A As Range
  3. If Target.Address <> "$C$3" Then Exit Sub
  4. Set A = Sheet1.Columns("A:A").Find(Target, lookat:=xlWhole)
  5. If A Is Nothing Then Exit Sub
  6. [C4].Resize(10, 1) = A.Offset(, 1).Resize(, 10).Value
  7. [C14] = A.Offset(, 11) & A.Offset(, 12)
  8. End Sub
½Æ»s¥N½X
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 4# Hsieh
ÁÂÁª©¥D¤j¤j, °J¤ß·PÁÂ, ¯¬§Ö¼Ö..

TOP

Hsieh ª©¥D¤j¤j,¦n
¤p§Ì¦³°ÝÃD½Ð±Ð, ²{§â°ÝÃD¼g©óÀɮפu§@ªí3, ½Ð¤j¤j±Ð¾É, ·P®¦
aa.rar (8.97 KB)

TOP

¥»©«³Ì«á¥Ñ ©P¤j°¶ ©ó 2012-4-24 18:54 ½s¿è

transpose.rar (20.27 KB) ¦^´_ 2# register313
¤j¤j, ¦n
¤p§Ì¸Õ¥Î¤j¤j¨ç¼Æ, ³o±ø¨ç¼Æ§¡¥Î¤W°}¦C
=TRANSPOSE(OFFSET(Sheet1!B3:K3,MATCH(C3,Sheet1!A3:A18,0)-1,0))
=VLOOKUP(C3,Sheet1!A3:M18,12,0)&VLOOKUP(C3,Sheet1!A3:M18,13,0)
b3:k3¬O¶Ç¦^Äæ¦ìb¦Ük, a3:a18¬O½d³ò, «ö­Y§ïÅܽd³ò, a1:1000, ¹ï¸Ü²°¼u¥X´£¥Ü, ¤£¯à§ïÅÜ°}¦C¤@³¡¥÷, ½Ð±Ð¤j¤j, ­Y§â½d³ò­Y¤j¬O¦p¦ó­×§ï
ÁÂÁÂÁÂ!

TOP

¦^´_ 7# ©P¤j°¶

½Ð¸Ô¬Ý2#¤§¾Þ§@¨BÆJ
transpose.rar (22.5 KB)

TOP

¦^´_ 6# ©P¤j°¶
  1. Private Sub Worksheet_Change(ByVal Target As Range)
  2. Dim A As Range
  3. If Target.Address <> "$C$3" Then Exit Sub
  4.   Set A = Sheet1.Columns("A:A").Find(Target, lookat:=xlWhole)
  5. If A Is Nothing Then Exit Sub
  6.   [C4].Resize(10, 1) = Application.Transpose(A.Offset(, 1).Resize(, 10).Value)
  7.   [C14] = A.Offset(, 11) & A.Offset(, 12)
  8. End Sub
½Æ»s¥N½X
aa.rar (9.17 KB)

TOP

¦^´_ 9# register313
Á¹L¤j¤j¦^À³,  °J¤ß·PÁÂÁÂ!!,

TOP

        ÀR«ä¦Û¦b : µÊ®ð¼L¤Ú¤£¦n¡A¤ß¦a¦A¦n¤]¤£¯àºâ¬O¦n¤H¡C
ªð¦^¦Cªí ¤W¤@¥DÃD