- ©«¤l
- 617
- ¥DÃD
- 17
- ºëµØ
- 0
- ¿n¤À
- 662
- ÂI¦W
- 1
- §@·~¨t²Î
- WINDOWS 7
- ³nÅ骩¥»
- OFFICE 2013
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- Pingtung
- µù¥U®É¶¡
- 2011-9-2
- ³Ì«áµn¿ý
- 2024-3-7
|
¥»©«³Ì«á¥Ñ 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)
|