¦p¦ó¦b¦P¤@®æ¤U©Ô¿ï³æ¦A¼W¥[VLOOKUP
- ©«¤l
- 5
- ¥DÃD
- 3
- ºëµØ
- 0
- ¿n¤À
- 18
- ÂI¦W
- 0
- §@·~¨t²Î
- v7
- ³nÅ骩¥»
- 2003
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-9-24
- ³Ì«áµn¿ý
- 2023-6-3
|
¦p¦ó¦b¦P¤@®æ¤U©Ô¿ï³æ¦A¼W¥[VLOOKUP
½Ð°Ý¤@¤U¤j¤j~
¦]§Ú¦³¤@¨Ç¤å¦r¦³°µ¤U©Ô¦¡¿ï³æ
¤£¹Ln¦p¦ó±NVLOOKUP¥[¤J¸Ì±©O?
¦p:
¤U©Ô¦¡¿ï³æ¤å¦r¬°
1.ÅU«È·N¨£ªí¥Ó½Ð¤A®×
2.ÅU«È©ê«è¥Ó½Ð¤A®×
3.ÅU«È¼úÀy¥Ó½Ð¤A®×
¥i¥H±N¦P¤@®æ¼W¥[¤U¦C¤å¦r¶Ü?=VLOOKUP($S6,Sheet2!B2:S24,2,FALSE)¡÷¤H¦W
¤]´N¬O·Qn§eÄm
1.ÅU«È·N¨£ªí"¤ý¤p©ú"¥Ó½Ð¤A®×
2.ÅU«È©ê«è"³¯¤j©ú"¥Ó½Ð¤A®×
3.ÅU«È¼úÀy"¼WÄÁ©ú"¥Ó½Ð¤A®×
¥H¤W¦A³Â·Ð¤j¤j¤F~
·PÁÂ! |
|
|
|
|
|
|
- ©«¤l
- 396
- ¥DÃD
- 12
- ºëµØ
- 0
- ¿n¤À
- 425
- ÂI¦W
- 1
- §@·~¨t²Î
- Win10
- ³nÅ骩¥»
- Office 2016
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¤¤
- µù¥U®É¶¡
- 2013-7-2
- ³Ì«áµn¿ý
- 2024-8-23
|
¥»©«³Ì«á¥Ñ owen06 ©ó 2013-8-16 10:03 ½s¿è
¦^´_ 1# fmsc168
¤£ª¾¹D³o¼Ë¦³¨S¦³À°¨ì§Aªº¦£¡G
¥»¨Ó§Aªº²M³æ¤º®eªºÀx¦s®æ¥u¬O³æ¯Âªº¤å¦r
1.ÅU«È·N¨£ªí¥Ó½Ð¤A®×
2.ÅU«È©ê«è¥Ó½Ð¤A®×
3.ÅU«È¼úÀy¥Ó½Ð¤A®×
²{¦b§â¥L§ï¦¨
1.="ÅU«È·N¨£ªí"&VLOOKUP($S6,Sheet2!B2:S24,2,FALSE)&"¥Ó½Ð¤A®×"
2.="ÅU«È©ê«è"&VLOOKUP($S6,Sheet2!B2:S24,2,FALSE)&"¥Ó½Ð¤A®×"
3.="ÅU«È¼úÀy"&VLOOKUP($S6,Sheet2!B2:S24,2,FALSE)&"¥Ó½Ð¤A®×"
³o¼Ë§A¦bS6¿é¤J¤§«á¡A²M³æ¤º®e´N¥i¥HÅܦ¨§Anªº¼Ë¦¡¤F |
|
|
|
|
|
|