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

[µo°Ý] §ì¨ú¥t¤@­ÓexcelÀɯS©w¸ê®Æ(¥H¸Ñ¨M)

[µo°Ý] §ì¨ú¥t¤@­ÓexcelÀɯS©w¸ê®Æ(¥H¸Ñ¨M)

¥»©«³Ì«á¥Ñ BV033DFG ©ó 2011-11-20 19:46 ½s¿è

§Ú·Q§ìExcelÀɪº¯S©w¸ê®Æ¡A
³o¬O¬YÀɪº¸ê®Æ

¦pªG§Ú·Q¦b¤£¶}±Ò¬YÀɪº±¡ªp¤U¡Aª½±µ§ì¸Ì­±"¤W®üAªÑ"B4Ä檺¸ê®Æ¸Ó«ç»ò°µ¡H
¬O¥ÎVLOOKUP¨ç¼Æ¶Ü¡H
¦ý¬O¥ÎVLOOKUP§Ú¤£ª¾¹D¦p¦ó§ì¥t¤@­ÓExcelªº¸ê®Æ¡A
§Úª½·Q¤£³z¡A§Æ±æ¦³¤Hª¾¹D¡A·PÁÂ!!

¥ý§â¨â­ÓÀɮצP®É¶}±Ò¡A¿é¤J¤½¦¡´N«Ü¤è«K¡I
jdfw.gif

TOP

¦^´_ 2# oobird


  ³o©Û¤£¿ù¥Î¡A·PÁ­ò~

¥t¥~°Ý¤@¤U¡Aª½±µÂIªº¸Ü¥L°Ñ·Ó¦ì¸m·|ª½±µ¶]¥X
=VLOOKUP([¥X³f¸ê®Æ.xml]Sheet1!$A$12,[¥X³f¸ê®Æ.xml]Sheet1!$A$2:$E$35,2,FALSE)
¤W­±$A$12ªº³¡¤À¥i¥H¥Î¤å¦r¶Ü¡H¦]¬°§Ú¥D­n¬O­n·j´M¤å¦r«á­±ªº¸ê®Æ¡A¦Ó¤£¬O·j´MÄæ¦ì
¹³¬O=VLOOKUP([¥X³f¸ê®Æ.xml]Sheet1!"¤W®üAªÑ",[¥X³f¸ê®Æ.xml]Sheet1!$A$2:$E$35,2,FALSE)
·PÁ±zªº¦^ÂЭò~

TOP

¦^´_ 3# BV033DFG
¥X³f¸ê®Æ.xml]Sheet1¤u§@ªí¤W ©w¸q¦WºÙ  "¤W®üAªÑ"  =$A$12

TOP

¦^´_ 4# GBKEE


   ½Ð°Ý³o­Ó¬O­n§ó°Ê[¥X³f¸ê®Æ.xls]ªº¤º®e¶Ü¡H
¦³¨S¦³¿ìªk¦b¤£§ó°Ê[¥X³f¸ê®Æ.xls]¤º®eªº±¡ªp¤U°µ¨ì¡A
¦]¬°¦³«Ü¦h­ÓexcelÀɮסA§Ú­n±N¸Ì­±ªº¸ê®Æ·J¶°¨ì¤@±iexcel¤W­±¡A
©Ò¥H¨S¿ìªk¤@­Ó¤@­Ó¥h§ï¡A·Qª½±µ¥Î¤½¦¡§âÀɮתº¸ê®Æ§ì¨ì¸Ì­±¡A
²{¦bªº°ÝÃD¥D­n¥X¦b¡A§Ú¶}±Ò¥t¤@­ÓEXCELÀɪ½±µÂI¿ï·|Åܦ¨¹³³o¼Ë
=VLOOKUP([¥X³f¸ê®Æ.xml]Sheet1!$B$4,[¥X³f¸ê®Æ.xml]Sheet1!$A$2:$E$35,2,FALSE)

³o¼Ë·|Åܦ¨¥u¬O·j´MB4Äæ¦ì¸Ì­±ªº¤º®e¡A¦Ó¤£¬O"¤W®üAªÑ"«á­±ªº¸ê®Æ¡A
¦pªG"¤W®üAªÑ"¦ì¸m§ïÅÜ¡A´N§ä¤£¨ì§Ú­nªº¼Æ¾Ú¤F¡A§Æ±æ³o¼Ëªí¹F°÷²M·¡~~

TOP

¦^´_ 5# BV033DFG
½Ð°Ý³o­Ó¬O­n§ó°Ê[¥X³f¸ê®Æ.xls]ªº¤º®e¶Ü¡H

¦p¹Ï   ¥X³f¸ê®Æ.xls   ¤¤ ¤@¤@ ªº©w¸qªÑ²¼ ¦sÀÉ«áÃö³¬  

¥´¶}ÀÉ®×Áä¤J=VLOOKUP([¥X³f¸ê®Æ.xml]Sheet1!¤W®üAªÑ,[¥X³f¸ê®Æ.xml]Sheet1!$A$2:$E$35,2,FALSE)


TOP

        ÀR«ä¦Û¦b : ¡i°µ¤Hªº¶}©l¡j¨C¤@¤Ñ³£¬O¬G¤Hªº¶}©l¡A¨C¤@­Ó®É¨è³£¬O¦Û¤vªºÄµ±§¡C
ªð¦^¦Cªí ¤W¤@¥DÃD