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

[µo°Ý] ¤½¦¡¹Bºâ«á,Àx¦s®æÅã¥Üªº°ÝÃD

[µo°Ý] ¤½¦¡¹Bºâ«á,Àx¦s®æÅã¥Üªº°ÝÃD

§Ú®w¦sªí¸Ì­±¦³¤½¦¡ªºÄæ¦ì,«D±o­n§Ú¶}±Ò¤½¦¡¸Ì­±³sµ²ªº¨ä¥Lªí³æ¤§«á,¤~·|¥X²{¹Bºâ«áªº¼Æ¦r,ÁÙ¨S¶}±Ò¨ä¥L³sµ²ªºÀɮ׮ɳ£·|¥X²{######³o¼Ë,¦³¿ìªk­×¥¿¶Ü??

¤½¦¡¦³¤À©ö¥¢©Ê¨ç¼Æ»P«D©ö¥¢©Ê¨ç¼Æ
¬Ý§A¥Î¤°»ò¤½¦¡¨Ó³sµ²

«Øij¥Î«D©ö¥¢©Ê¨ç¼Æ
¦p=
vlookup()
hlookup()
index()

¦p¥Î©ö¥¢©Ê¨ç¼Æ«hÀÉ®×¥²»Ý¶}±Ò¤¤
­n±H°e¥²¶·­n½Æ»s¦¨­È
¦poffset()
indirect()
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

¤½¦¡¦³¤À©ö¥¢©Ê¨ç¼Æ»P«D©ö¥¢©Ê¨ç¼Æ
­ì¨Ó¦p¦¹
¨ü¯q¤F¡A·PÁÂ
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 2# gong


    ­ì¨Ó¦³¨Ç¨ç¼Æ¦³©ö¥¢©Ê°ÝÃD³á
   Ãø©Ç¦³®É­Ô¥Î¨º¨Ç¨ç¼Æ®e©ö¥X²{¨º¨Çµe­±
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ

TOP

­ì¨ÓÁÙ¦³¤À©ö¥¢©Ê¸ò«D¥¢©Ê
§Ú©ö¥¢©Êªº±`¥Î¨C¤Ñ·|¼W¥[¸ê®Æªº¦Û­q¦WºÙ¤¤
ª½±µ¿ï¨ú¤@­Ó½d³ò°µ¼Ï¶s¦³®É³£·|¦³°ÝÃD
¤£ª¾¹D­n¦p¦ó¥H«D¥¢©Êªº¨ç¼Æ¨ú¥Noffset
Åý¦Û­q¦WºÙªº½d³ò¥i¥HÀHµÛ¸ê®Æªº¼W¥[¦Ó§ïÅÜ

TOP

        ÀR«ä¦Û¦b : ­n¥Î¤ß¡A¤£­n¾Þ¤ß¡B·Ð¤ß¡C
ªð¦^¦Cªí ¤W¤@¥DÃD