- ©«¤l
- 186
- ¥DÃD
- 6
- ºëµØ
- 0
- ¿n¤À
- 218
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- office 2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2012-11-12
- ³Ì«áµn¿ý
- 2014-4-15
|
¦^´_ 16# ã´£³¡ªL
ì¨Óvlookup¥i¥H¨Ï¥Î¸U¥Î¦r¤¸¡A¨ü±Ð¡I
©Ò¥HìpoÀɮתºì©l¤½¦¡- =VLOOKUP(LEFT(ªí®æ5[[#³oÓ¦C],[¤¤¤å®v¦W]],6),ªí®æ__2003sv_CHIComp01_comCustomer[[#¥þ³¡],[InvoiceHead]:[ID]],2,0)
½Æ»s¥N½X ¥unµy·Lקאּ- =VLOOKUP("*"&ªí®æ5[[#³oÓ¦C],[¤¤¤å®v¦W]]&"*",ªí®æ__2003sv_CHIComp01_comCustomer[[#¥þ³¡],[InvoiceHead]:[ID]],2,0)
½Æ»s¥N½X §Y¥i¹F¦¨©M§Ú¤½¦¡¬Û¦Pªº®ÄªG
¦Ü©ó=LOOKUP(9^9,FIND(A1,D1:D4),E1:E4)
·í¦³¤£¥u¤@ӲŦX®É¡A·|¦^¶Ç¡u²Å¦Xªº¦r¦ê¬O¦b³Ì«á±ªº¡v²Å¦X¶µ¥Ø¡A·Pı¦³ÂIÀH¾÷ |
|