- ©«¤l
- 61
- ¥DÃD
- 20
- ºëµØ
- 0
- ¿n¤À
- 106
- ÂI¦W
- 21
- §@·~¨t²Î
- winds XP
- ³nÅ骩¥»
- 2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2014-1-21
- ³Ì«áµn¿ý
- 2024-5-11
|
¤W¦¸©Ò»¡ªº°ÝÃD¤wok¡A¦ýèµo²{«È¤á©Òµ¹ªºexcelªí³æ¤w¦³©w¸q¦WºÙ¥B¤£¥iÅÜ°Ê¡C
©Ò¥H«·s³¯z¤@¦¸¥Ø«eªºª¬ªp
1. Sheet1¤w©wij¬°"Print_Area"¡ö¤£¥i§ó§ï
¶µ¥Ø¬°A1=po¡BB1=item¡BC1=desc
2. Sheet2©wij¦WºÙ¬°¡¨¸ê®Æ¡¨¡ö¥i§ó§ï
¶µ¥Ø¬°A1=¬y¤ô½s¸¹¡BB1=item¡BC1=desc
Q¡Gn¦bSheet1 B2¿é¤Jitem µM«áC2·|¦Û«§ì¨úSheet2ªºCÄæ¸ê®Æ
§Ú¦bsheet1 C2¿é¤J¤½¦¡=VLOOKUP(B2,¸ê®Æ,3,0)
¥¿±`¿é¤J§¹¤½¦¡¦p¥¿½TÀ³¸Ó·|¦bC2Åã¥Ü#N/A
¦ý§ÚªºC2½T¬OÅã¥Ü§ÚªÅ¥´ªº¤½¦¡=VLOOKUP(B2,¸ê®Æ,3,0)
½Ð°Ý¤½¦¡À³¸Ó¦p¦ó×¥¿¤~¹ï |
|