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

[µo°Ý] VLOOKUP·j´M¥X¨Óªº¸ê®Æ¶W³sµ²µLªkÅã¥Ü

[µo°Ý] VLOOKUP·j´M¥X¨Óªº¸ê®Æ¶W³sµ²µLªkÅã¥Ü

ECXEL¥ÎVLOOKUP´M§ä¥X¨Óªº¸ê®Æ¡A
­ì©lÀɮר䤤¦³¤@Àx¦s®æ¡A³]¦³¶W³sµ²¡C
´M§ä¥X¨Óªº¸ê®Æ¥u¦³Åã¥Ü¤å¦r¡A¶W³sµ²ªº³¡¥÷µLªk±a¥X¡C
½Ð°Ý¨ç¼Æ­n¦p¦ó³]©w¡A¤~¯àÅý¶W³sµ²ªº³¡¥÷¤]¯àÅã¥Ü¥X¨Ó?
ÁÂÁÂ

¦^´_ 11# sunnyso


    §Ú¸Õ¥X¨Ó¤F,¯uªº­n¤À2®æ¤£¦PªºÀx¦s®æ,
    ¤§«e¸Õ¤£¦¨¥\¬O¦]¬°§Ú¬O¥Îºô¸ôªÚ¾F§ì§O¥x¹q¸£¦ì¸m¤~¤@ª½¥¢±Ñ¡C
    «á¨Ó§â¥L­Ì³£¦s¦b§Ú¦b¨Ï¥Îªº¹q¸£´NOK¤F
    ÁÂÁ§A~

TOP

½Ðµ¹³¡¤ÀÃþ¦üªº¹ê»Ú¸ê®Æ¨Ó¬Ý¬Ý
ss

TOP

¦^´_ 8# sunnyso


    ¤À¶}¨â­ÓÀx¦s®æ¨Ó¼g ·|Åã¥Ü "³o­Óºô¯¸ªº¦ì§}µL®Ä¡A½Ð®Ö¹ï¦a§}«á­«¸Õ"
    ³o¬O¦]¬°§Ú·Q­n³sµ²ªº¬OÀÉ®× ¦Ó¤£¬Oºô­¶¶Ü?

TOP

¦^´_ 7# sunnyso


    34®æªº¸ê®Æ ¬O ³sµ²¨ì¾P³f©ú²ÓÀÉ¡A·Q­nª½±µ±q¬d¸ß³æÂI¨ú¡A´N¯à¸õ¥X«È¤áªº¾P³f¾ú¥v°O¿ý

TOP

¤À¶}¨â­ÓÀx¦s®æ¨Ó¼g

A1 = vlookup(     ,     ,     ,   )
A2 = hyperlink(A1)
ss

TOP

VLOOKUP($C$2,'Z:\«È¤á¸ê®Æ®w\[«È¤á¸ê®Æ.xls]Sheet1'!$AAK,34,0)

34Ä檺¸ê®Æ®æ¦¡¬O¤°»ò?
ss

TOP

¦^´_ 5# pomeloyi

§Q¥Î°Ñ¼Æ¸ê®Æ¬d¸ß¡A¯¸¤º¦³«Ü¦hÃþ¦ü®×¨Ò¡A¥i¦hª¦¤å¬Ý¬Ý
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 5# sunnyso


    sunnyso±z¦n¡A
   ÁÂÁ±zªº¦^ÂСA¦ý§Ú¤£·|¥Î¥¨¶°¡A¤£ª¾¹D­n«ç»ò¶}©l =¤f="

   §Ú²{¦b¬O¤@­ÓÀɮ׬O«È¤á¸ê®Æ®w¡A¤@­ÓÀɮ׬O¬d¸ßÀÉ¡A
   «á¨Óµo²{¡A§Ú¥²¶·­n¨â­ÓÀɮצP®É¶}±Ò¡A¶W³sµ²¤~·|¦³°Ê§@¡C
   ¦³¤°»ò¤èªk¥i¥H¥u¶}¬d¸ßÀÉ´N¯àª½±µ³sµ²¶}±Ò¶W³sµ²©O?
   ¦]¬°§Ú·Q¦b¨C­Ó¦P¨Æªº®à­±©ñ¤@­Ó¬d¸ßÀÉ ¦Û°Ê³sµ²¨ì¸ê®Æ®w¸Ì¡A
   µM«á¥i¥H±a¥X¨C­Ó«È¤áªº¾P³f©ú²Ó¤è«K«È¤á¥´¹q¸Ü¨Ó®É¥i¥Hª½±µ°µ¬d¸ß
                                    ÁÂÁÂ

TOP

¦^´_ 4# pomeloyi

¥i¯à¦]¬°储¦s®æÅã¥Üªº¤º®e¤£¬OURL

¨Ò¦p A1 Åã¥Ü¤º®e爲 "­q³f³æ", ¨ä¶W³sµ²爲 "z:\abcd.xlsx"
¥Î¤U­±ªºfunction HLink ¥i¥H±o¨ìA1ªº¶W³sµ²

=HLink(A1)

'==start of function HLink==========
Function HLink(rng As Range) As String
'extract URL from hyperlink
'posted by Rick Rothstein
  If rng(1).Hyperlinks.Count Then HLink = rng.Hyperlinks(1).Address
End Function
ss

TOP

        ÀR«ä¦Û¦b : ºÉ¦h¤Ö¥»¥÷¡A´N±o¦h¤Ö¥»¨Æ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD