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

½Ð°Ý¦b¤é´Á¤Î©m¦W¤U§ä¥X¬ÛÃö¸ê®Æ,

½Ð°Ý¦b¤é´Á¤Î©m¦W¤U§ä¥X¬ÛÃö¸ê®Æ,

½Ð°Ý¦p¦ó¥Î¤½¦¡§ä¥X 1Sep2016 ªL®Û©úªº Á~ª÷¤Î, ¾¦ì ¬O $16,000 ¤Î ¤å­û
½Ð«ü±Ð

¥Í®Ä¤é´Á        ©m¦W        Á~ª÷        ¾¦ì
01Jan2015        ªL®Û©ú        $13,000.00         ¤å­û
01Jan2016        ªL®Û©ú        $16,000.00         ¤å­û
01Jan2017        ªL®Û©ú        $17,230.00         ¤å­û
01Jan2015        ±ç¥ò¤å        $12,000.00         ¤å­û
01Jan2016        ±ç¥ò¤å        $14,000.00         ¤å­û
01Jan2017        ±ç¥ò¤å        $17,500.00         °ª¯Å¤å­û
01Jan2015        ³¯¤­©÷        $13,000.00         ·|­p
01Jan2016        ³¯¤­©÷        $14,500.00         ·|­p
01Jan2017        ³¯¤­©÷        $16,100.00         °ª¯Å·|­p
01Jan2015        ½²§ÓÃô        $13,000.00         ¤å­û
01Jan2016        ½²§ÓÃô        $12,530.00         ¤å­û
01Jan2017        ½²§ÓÃô        $14,110.00         ¤å­û

Sample.zip (51.6 KB)

ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

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

¦^´_ 1# enoch
VLOOKUP-¤ñ¹ïÂùÄæ(¦P&¤£¦PSheet).rar (17.3 KB)
ÃD·N»Ý¨D¡J¥H¤u§@ªí¦P¦CªºAÄæ©MBÄ椧²Õ¦X­È¡A·j´M¹ïÀ³ªºCÄæ©MDÄ椧²Õ¦X­È

°²³]~Sheet1ªºAÄæ©MBÄ椧¦U²Õ¦X­È¨S¦³­«½Æ~«h
¬Û¦P¤u§@ªí®É¡JSheet1ªºI1¤½¦¡
=IF(OR(G1="",H1=""),"",VLOOKUP($G1&$H1,IF({1,0},$A$1:$A$100&$B$1:$B$100,C$1:C$100),2,))
°}¦C¤½¦¡~¿é¤J¤½¦¡«á~Shift¡BCtrl¡BEnter¤TÁä»ô«ö~
¥k©Ô¨ìJ1¡A¦A¤U©Ô¶ñº¡§Y¥i!

¦bGÄæ©MHÄæ¶ñ¤J·j´Mªº²Õ¦X«á~IÄæ©MJÄæ§Y·|Åã¥Ü¥X¹ïÀ³ªºCÄæ©MDÄæ²Õ¦X
$100¦C¤£°÷¥Î®É¡A¥i¦Û¦æ¼W­×¦C¼Æ¡A¦A±N¤½¦¡­«·s©¹¥k©¹¤U©Ô¡C

¤£¬Û¦P¤u§@ªí®É¡J,Sheet2ªºC1¤½¦¡
=IF(OR(A1="",B1=""),"",VLOOKUP($A1&$B1,IF({1,0},Sheet1!$A$1:$A$100& Sheet1!$B$1:$B$100,Sheet1!C$1:C$100),2,))
°}¦C¤½¦¡~¿é¤J¤½¦¡«á~Shift¡BCtrl¡BEnter¤TÁä»ô«ö~
¥k©Ô¨ìD1¡A¦A¤U©Ô¶ñº¡§Y¥i!

¦bAÄæ©MBÄæ¶ñ¤J·j´Mªº²Õ¦X«á~IÄæ©MJÄæ§Y·|Åã¥Ü¥X¹ïÀ³ªºCÄæ©MDÄæ²Õ¦X
$100¦C¤£°÷¥Î®É¡A¥i¦Û¦æ¼W­×¦C¼Æ¡A¦A±N¤½¦¡­«·s©¹¥k©¹¤U©Ô¡C

TOP

¥»©«³Ì«á¥Ñ 013160 ©ó 2017-10-22 19:42 ½s¿è
¦^´_  enoch

ÃD·N»Ý¨D¡J¥H¤u§@ªí¦P¦CªºAÄæ©MBÄ椧²Õ¦X­È¡A·j´M¹ïÀ³ªºCÄæ©MDÄ椧²Õ¦X­È

°²³]~Sheet1ªº ...
Airman µoªí©ó 2017-10-9 15:36


1.PNG
2017-10-22 19:37
[attachimg]27846
[/attachimg] 123.rar (899.25 KB)

½Ð°Ýª©¤j§Úªº¤½¦¡¬O¿ù¦b­þ!?
¬°¦óµLªkÅã¥Ü¥X§Ú­nªº¸ê®Æ
­n¥ÎITI¤¤­q³æ¸¹½X©M«¬¸¹±o¨ìSNRK»s¥O³æ¸¹
½Ðª©¤j«ü±Ð¡AÁÂÁÂ!!
2.PNG

TOP

        ÀR«ä¦Û¦b : ¤H­n¦Û·R¡A¤~¯à·R´¶¤Ñ¤Uªº¤H¡C
ªð¦^¦Cªí ¤W¤@¥DÃD