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

[µo°Ý] VLOOKUP¶W³sµ²°ÝÃD

[µo°Ý] VLOOKUP¶W³sµ²°ÝÃD

½Ð°Ý¤@¤U
§Ú¦bSheet2«Ø¥ß¤å¦r¸ê®ÆÀÉ¡A¨ä¤¤ªº²Ä¤­¦C¬O¶W³sµ²¨ìSheet3¦U­ÓÀx¦s®æ¦ì¸mªº³sµ²ÂI¡C

Sheet1¤¤§Ú¥ÎVLOOKUP·j´M¸ê®Æ¦ý¨ä¤¤ªº¤å¥ó¤º¶W³sµ²¤@ª½¥X¤£¨Ó¡A¸Õ¹LHyperlink¤]¤@¼Ë
¡A¬O·|¥X¨Ó¤@­Ó³sµ²ÂI¡A¦ý¨º­Ó³sµ²ÂI¬O¿ù»~ªº³sµ²ÂI¡A¤£¬O­ì¥»Sheet2¤¤ªº¶W³sµ²ÂI¡C

¤£¾å±oÁÙ¦³§Oªº¤èªk¥i¥HÅýVLOOKUP¥i¥H¦^¶Ç§¹¾ãªº¶W³sµ²ÂI¦Ó¤£¬O¦r¦ê¶Ü¡HÁÂÁ¡C

¨S¤H¦^§A¬O¦]¬°¤j®a¤£ª¾¹D§A­nªº¬O¤°»ò,½Ðªþ¤WEXCELÀ£ÁYÀÉ,¨Ã¤â°Ê¶ñ¤W­nªºµ²ªG,§_«h²q¤£¥X§A°ÝÃD.

TOP

¦^´_ 1# acenova

Sheet1 : B1=HYPERLINK("[HYPERLINK.XLS]"&VLOOKUP(A1,Sheet2!$A$1:$B$5,2,0),VLOOKUP(A1,Sheet2!$A$1:$B$5,2,0))
Sheet2 : B1~B5³]©w¦n³s¨ìSheet3¬Û¹ïÀx¦s®æ¤§¶W³sµ²

1.gif

TOP

        ÀR«ä¦Û¦b : ¯à·F¤£·F¡A¤£¦p­W·F¹ê·F¡C
ªð¦^¦Cªí ¤W¤@¥DÃD