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

[µo°Ý] HYPERLINKµ²¦XVLOOKUPªºÀ³¥Î½Ð¯q

[µo°Ý] HYPERLINKµ²¦XVLOOKUPªºÀ³¥Î½Ð¯q

¥»©«³Ì«á¥Ñ hollou ©ó 2015-3-5 14:56 ½s¿è

½Ð°Ý¦U¦ì°ª¤â,À°§Ú¬Ý¤@¤U¬O­þ¸Ì¥X¤F°ÝÃD©O? ÁÂÁÂ

a1Àx¦s®æ«Ø¥ß¤U©Ô¦¡¿ï³æ..¤º®e1.2.3
©IÀ³sheet2ªº¦WºÙ»P¶W³sµ²
¦ý¿ï¾Ü®É,¤å¦r·|¸òµÛÅÜ°Ê,¦ý¶W³sµ²³£µLªk¶}±Ò,(ª½±µ«ösheet2ªº¶W³sµ²¥i¶}±Ò)
°ÝÃD¦pªþ¥óÀÉ®×
b2=HYPERLINK(VLOOKUP(A1,Sheet2!$A$1:$B$3,2,0),VLOOKUP(A1,Sheet2!$A$1:$B$3,2,0))

Book1.rar (6.87 KB)

TOP

¥»©«³Ì«á¥Ñ p212 ©ó 2015-3-5 15:57 ½s¿è

¦^´_ 1# hollou
Sheet1Àx¦s®æB2¿é¤J
=HYPERLINK(VLOOKUP($A$1,Sheet2!$A$1:$C$3,3,),VLOOKUP($A$1,Sheet2!$A$1:$C$3,2,))
½Ð°Ñ¦Ò¡I
ps. ·s¼W¹Ï¥Ü¤§CÄæ¡A¨äºô§}¨Ó¦Û©ó·Æ¹«ÂI«öSheet2¤§BÄæ(Àx¦s®æB1¡BB2¡BB3)¡A«ö¥kÁä«á«ü©w¡u½s¿è¶W³sµ²¡v½Æ»s¨äºô§}§Y¥i¡C

fig.jpg (31.94 KB)

fig.jpg

TOP

1] Sheet2, ²K¥[ C1:C3, ¤À§O¿é¤Jºô§} :
http://yahoo.com.tw/
http://Google.com.tw
http://ruten.com.tw

2] Sheet1, B2 ¤½¦¡ §ï¬° :

=HYPERLINK(VLOOKUP(A1,Sheet2!$A$1:$C$3,3,0),VLOOKUP(A1,Sheet2!$A$1:$C$3,2,0))

TOP

1] Sheet2, ²K¥[ C1:C3, ¤À§O¿é¤Jºô§} :
http://yahoo.com.tw/
http://Google.com.tw
http://ruten.com. ...
JBY µoªí©ó 2015-3-5 16:07


¦¨¥\¤F,ÁÂÁ¦U¦ì!:D

TOP

        ÀR«ä¦Û¦b : ¨Ã«D¦³¿ú¾{¬O§Ö¼Ö¡A°Ý¤ßµL·\¤ß³Ì¦w¡C
ªð¦^¦Cªí ¤W¤@¥DÃD