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

[µo°Ý] ¦p¦ó±N³f¸¹A001¦b³»¦Cªº¤T±i¤u§@©³½Z¡A¥B¦X­p­È¶×¤JÁ`ªí¤º

[µo°Ý] ¦p¦ó±N³f¸¹A001¦b³»¦Cªº¤T±i¤u§@©³½Z¡A¥B¦X­p­È¶×¤JÁ`ªí¤º

§Æ±æ¶i1¡B¶i2»P¶i3µ¥¤u§@©³½Z¤¤³f¸¹¬°A001¤§¦X­p­È¶×
¤JA001Á`ªí¤º(µ²ªG¦pÁ`ªí¦C¥Ü)

Book11.rar (7.13 KB)

§Æ±æ¤ä«ù!

Book11.rar (8.18 KB)

TOP

=LOOKUP("¼_",INDIRECT("¶i"&ROW(A1)&"!B1:B99"))
½Ð°Ýª©¥DÁ`ªí¤¤¤é´ÁÄæ¡A§Y¤W­z¤½¦¡"¼_"¡A¬d¨Ó·½¸ê®Æ¡A¨ÃµL¦¹ÃöÁä¦r¡A½Ð°Ý¦³¦ó¥Î·N¡H
§Æ±æ¤ä«ù!

TOP

¦^´_ 3# s7659109

¼_¨ÃµL¥ô¦ó·N¸q,¥u¬O¥¦ªºcode() ¤ñ¤@¯ë±`¥Î¦r¤j¦Ó¤w,¸ò¼Æ¦r¥Î4^8¦P¼Ë¥\¥Î

TOP

Á`ªí­ì°²³]¶×¤J³f¸¹A001¡A¦ý¦p§ï¦¨A002©ÎA003
«h·|¥X²{¤½¦¡¿ù»~¡C

Book12.rar (1.57 KB)

Book11-1.rar (7.04 KB)

Book11-1.rar (7.04 KB)

§Æ±æ¤ä«ù!

TOP

2007¥H¤W¥ÎIFERROR()
2003¥ÎIF()+ISERROR()°£¿ù§Y¥i

TOP

        ÀR«ä¦Û¦b : ¤Hªº¤ß¦a¬O¤@²¥¥Ð¡A¤g¦a¨S¦³¼½¤U¦nºØ¤l¡A¤]ªø¤£¥X¦nªºªG¹ê¡C -
ªð¦^¦Cªí ¤W¤@¥DÃD