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

[µo°Ý] Vlookup«ç°µ½Æ¦XÀ³¥Î

gif¬Ý¤£¨ì¤ÓÀ´³]©w¹Lµ{~~~¥i¬O¬Ý°_¨Ó¹³¬O EXL+ACCESS¤@°_°µ¥X¨Óªº¶Ü?
¥ÎACCESS°µ¸ê®Æ®w¡AµM«á¥ÎEXCEL°µ¬d¸ßªí³æªº·N«ä¶Ü?

ACCESS¤£¬O³£­n¥ÎACCESS¦Û¤v°µ"¬d¸ßªí³æ"¨Ó¥Î?
¥i¥H¥ÎEXCEL°µªí³æ¡A¥h¬dACCESSªº¸ê®Æ¶Ü??

TOP

§Ú¥ÎINDEX¥i²Å¦X»Ý¨D(¨ú¥N¬d¸ß2­Ó±ø¥óªºVLOOKUP)¡A¦ý¤]Åýªí®æÅܱo«ÜºC¡C
½Ð°Ý¡A·ÓµÛHsieh¤jªº¨BÆJ...
°Ñ¼Æ­Èªº¨Ó·½¤@¦¸¥u¯à¬d¤@µ§¶Ü? ­Y¬OA2¬dªºµ²ªGÅã¥Ü©óB2.C2¡AA3¬dªºµ²ªGÅã¥Ü©óB3.C3¡A¬O§_´N¤£¾A¦X¥Î¦¹¤èªk¤F?©ÎÀ³¦p¦ó§ï©O¡AÁÂÁ¡C

TOP

        ÀR«ä¦Û¦b : ¯à¥I¥X·R¤ß´N¬OºÖ¡A¯à®ø°£·Ð´o´N¬O¼z¡C
ªð¦^¦Cªí ¤W¤@¥DÃD