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

¦p¦ó¦b¦P¤@®æ¤U©Ô¿ï³æ¦A¼W¥[VLOOKUP

¦p¦ó¦b¦P¤@®æ¤U©Ô¿ï³æ¦A¼W¥[VLOOKUP

½Ð°Ý¤@¤U¤j¤j~
¦]§Ú¦³¤@¨Ç¤å¦r¦³°µ¤U©Ô¦¡¿ï³æ
¤£¹L­n¦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·Q­n§eÄm
1.ÅU«È·N¨£ªí"¤ý¤p©ú"¥Ó½Ð¤A®×
2.ÅU«È©ê«è"³¯¤j©ú"¥Ó½Ð¤A®×
3.ÅU«È¼úÀy"¼WÄÁ©ú"¥Ó½Ð¤A®×

¥H¤W¦A³Â·Ð¤j¤j¤F~
·PÁÂ!

¥»©«³Ì«á¥Ñ 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Åܦ¨§A­nªº¼Ë¦¡¤F

TOP

        ÀR«ä¦Û¦b : ¡i®É¶¡¦¨´N¤@¤Á¡j®É¶¡¥i¥H³y´N¤H®æ¡A¥i¥H¦¨´N¨Æ·~¡A¤]¥i¥HÀx¿n¥\¼w¡C
ªð¦^¦Cªí ¤W¤@¥DÃD