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

[µo°Ý] §ä¥X³Ì±µªñ¥B¤j©óªº¤é´Á

[µo°Ý] §ä¥X³Ì±µªñ¥B¤j©óªº¤é´Á

1. ¥HBÄ欰·j´MKey
2. §ä¥XFedex.sheetªºDÄæ³Ì±µªñ¥B¤j©óªº¤é´Á
3. ±NFedex.sheet HÄ檺­È¥N¤JFSCªºGÄ椤
4. ¨DGÄ椽¦¡

§ä¥X³Ì±µªñ¥B¤j©óªº¤é´Á.rar (11.07 KB)

¤£¦n·N«ä §Ú¬Ý¤£À´§Aªº·N«äÕÙ
3. ±NFedex.sheet HÄ檺­È¥N¤JFSCªºGÄ椤
¬O¤£¬O·N«ä¬O¬Û¤Ïªº­n§âFSCªºGÄæ±a¤JFedex.sheet HÄæ?

TOP

¦^´_ 2# zheng211016

©êºp,§Ú¼g¤Ï¤F,­«¼g¦p¤U¡G
1        ¥HFedex.sheet BÄ欰·j´MKey
2        §ä¥XFSCªºDÄæ³Ì±µªñ¥B¤j©óªº¤é´Á
3        ±NFSCªºHÄ檺­È¥N¤JFedex.sheet GÄ椤
4        Fedex.sheet GÄæ¬O§Ú­nªºµª®×,¦ý¨D¤½¦¡

TOP

¥»©«³Ì«á¥Ñ naruto018 ©ó 2017-9-15 08:30 ½s¿è
  1. FedexªºG2¶ñ¤J
  2. =INDEX(FSC!H:H,MATCH(VLOOKUP(B2,FSC!D:D,1,TRUE),FSC!D:D,0)+IF(VLOOKUP(B2,FSC!D:D,1,TRUE)=B2,0,1))
  3. ¨ä¾l¤U©Ô
½Æ»s¥N½X

TOP

¦^´_ 3# PJChen
¼ÐÃD¥Î"§ä¥X³Ì±µªñ¥B¤j©óªº¤é´Á"
¦ýFedexªºG7©Ò¨Dªº¬O¦P¤é´Áªº
©Ò¥H¤½¦¡·|¬O¤W­±¨º­Ó¤½¦¡(¨D±o¤é´Á¤j©óµ¥©ó)

¦pªG¬O³£­n¤j©ó¡A«h§ï¦¨¤U­±ªº¤½¦¡
  1. =INDEX(FSC!H:H,MATCH(VLOOKUP(B2,FSC!D:D,1,TRUE),FSC!D:D,0)+1)
½Æ»s¥N½X

TOP

¥»©«³Ì«á¥Ñ fengetianxia ©ó 2017-9-15 10:31 ½s¿è

FSC¤é´Á¬O¶¶§Ç±Æ¦Cªº¸Ü´N

=OFFSET(FSC!$H$2,COUNTIF(FSC!$D$2:$D$200,"<"&Fedex!B2),)

TOP

=VLOOKUP(SMALL(FSC!D:D,COUNTIF(FSC!D:D,"<"&B2)+1),FSC!D:H,5,)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¥»©«³Ì«á¥Ñ hcm19522 ©ó 2017-9-15 12:15 ½s¿è

{=INDEX(FSC!H:H,MATCH(,0/(FSC!D$2:D$12>B2),)+1)
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

¦^´_ 4# naruto018
³o­Ó¤½¦¡¤~¬O§Ú­nªºµª®×,¦]¬°¬O­n³Ì±µªñ©Î¤j©óªº¤é´Á,¦ý¤é´Á¬Û¦P®É´N¤£¯à¥N¥X¤j©óªº¨º­Ó¶×²v¡I
=INDEX(FSC!H:H,MATCH(VLOOKUP(B2,FSC!D:D,1,TRUE),FSC!D:D,0)+IF(VLOOKUP(B2,FSC!D:D,1,TRUE)=B2,0,1))

¦^´_ 6# fengetianxia
¦^´_ 7# ML089
·PÁ±z...¤½¦¡ok
   
¦^´_ 8# hcm19522
³o­Ó¤½¦¡¹J¨ì¤é´Á¬Û¦P®É·|¥X²{¿ù»~µª®×,¨Ò¦p¡G9/10¨ºµ§µª®×¬°10.50%,¦ý«o¥X²{12.50%
¦]¬°¬O­n³Ì±µªñ©Î¤j©óªº¤é´Á,¦ý¤é´Á¬Û¦P®É´N¤£¯à¥N¥X¤j©óªº¨º­Ó¶×²v¡I

TOP

2017-09-15_203857.png
2017-9-15 20:38

¥H¤W¬O§Ú­Ó¤H¨£¸Ñ

TOP

        ÀR«ä¦Û¦b : ª¾ÃÑ­n¥Î¤ßÅé·|¡A¤~¯àÅܦ¨¦Û¤vªº´¼¼z¡C
ªð¦^¦Cªí ¤W¤@¥DÃD