ªð¦^¦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¨Ó?
ÁÂÁÂ

=HYPERLINK(VLOOKUP(     ,       ,      ,     ))
ss

TOP

¦^´_ 2# sunnyso


±z¦n¡A
§Ú¦³¥Î¤F
=HYPERLINK((VLOOKUP($C$2,'Z:\«È¤á¸ê®Æ®w\[«È¤á¸ê®Æ.xls]Sheet1'!$A:$AK,34,0)),"¾P³f©ú²Ó")
¦³®É¥i¥H³sµ²¦¨¥\¡A¦³®É¶}±Ò«o¨S¦³¤ÏÀ³¡C¬O¤°»ò­ì¦]©O?

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

¦^´_ 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

¦^´_ 5# pomeloyi

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

TOP

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

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

TOP

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

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

TOP

¦^´_ 7# sunnyso


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

TOP

¦^´_ 8# sunnyso


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

TOP

        ÀR«ä¦Û¦b : ¬Ý§O¤H¤£¶¶²´¡A¬O¦Û¤v­×¾i¤£°÷¡C
ªð¦^¦Cªí ¤W¤@¥DÃD