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

[µo°Ý] excel°ÝÃD½Ð±Ð!!

[µo°Ý] excel°ÝÃD½Ð±Ð!!

°ÝÃD1.½Ð°Ý¤@¤U,Excel¦³¨ç¼Æ©Î¥¨¶°¥i¥H§ì¨ú¤@­Ó¸ê®Æ§¨¤U(¥]§t©Ò¦³¤l¸ê®Æ§¨)ªºexcelÀɯS©wÀx¦s®æ¶Ü?
°ÝÃD2.¥ÎHLOOKUP´M§ä¥X¨Óªº¹ïÀ³­È,®ÇÃä¥i¥HÅã¥Ü¸Ó¹ïÀ³­È®ÇÃä®æªº¸ê®Æ¶Ü?
¨Ò¦p§Ú¦³¨âµ§¸ê®Æ:A¬¡­¶Ã¯&B¬¡­¶Ã¯
A¬¡­¶Ã¯ °Ó«~A »ù¿ú100
B¬¡­¶Ã¯ °Ó«~A »ù¿ú199
¦bA¬¡­¶Ã¯¥ÎHLOOKUP´M§äB¬¡­¶Ã¯¸Ì¸ò"°Ó«~A"¤@¼Ëªº­È®ÇÃä®æ¦³¤èªk¥i¥HÃö³s¨ìB¬¡­¶Ã¯ªº"»ù¿ú199"¶Ü?

°ÝÃD1.½Ð°Ý¤@¤U,Excel¦³¨ç¼Æ©Î¥¨¶°¥i¥H§ì¨ú¤@­Ó¸ê®Æ§¨¤U(¥]§t©Ò¦³¤l¸ê®Æ§¨)ªºexcelÀɯS©wÀx¦s®æ¶Ü?
°ÝÃD2. ...
planeat µoªí©ó 2012-8-27 14:55

¦P®É¥´¶}¨â­ÓÀÉ®×.
LOOKUP¨ç¼Æ¤W¥[¤W¹ï¤èï¦W§Y¥i
=VLOOKUP(A1,[book2.xls]¤u§@ªí1!$A$1:$B$65536,2,FALSE)
À´±oµo°Ý,µª®×´N·|¦b¨ä¤¤

¤µ¤éの¤@¬íは  ©ú¤éにない
http://kimbalko-chi.blogspot.com
http://kimbalko.blogspot.com

TOP

¦P®É¥´¶}¨â­ÓÀÉ®×.
LOOKUP¨ç¼Æ¤W¥[¤W¹ï¤èï¦W§Y¥i
=VLOOKUP(A1,¤u§@ªí1!$A$1B$65536,2,FALSE)
kimbal µoªí©ó 2012-8-28 22:41

¸Ü»¡§Ú­è­è¤]§ä¥XVLOOKUP¤F,¤£¹LÁÙ¬OÁÂÁÂ!!

TOP

        ÀR«ä¦Û¦b : ¡i¦æµ½­n¤Î®É¡j¦æµ½­n¤Î®É¡A¥\¼w­n«ùÄò¡C¦p¿N¶}¤ô¤@¯ë¡A¥¼¿N¶}¤§«e¤d¸U¤£­n°±º¶¤õ­Ô¡A§_«h­«¨Ó´N¤Ó¶O¨Æ¤F¡C
ªð¦^¦Cªí ¤W¤@¥DÃD