±±¾©Ê¯ÓÍ»¯¹¤Ñ§Ôº2026ÄêÑо¿ÉúÕÐÉú½ÓÊÕµ÷¼Á¹«¸æ
²é¿´: 419  |  »Ø¸´: 9
µ±Ç°Ö÷ÌâÒѾ­´æµµ¡£

zhaozheng522

½ð³æ (СÓÐÃûÆø)

[½»Á÷] EXCEL ÎÊÌâ

¼ÙÈ繤×÷±í1µÄBÁÐÖÐijÐÐÊý¾Ý£¨Èç:B21£©µÈÓÚÔÚ¹¤×÷±í2 µÄCÁÐÖеÄijÐÐÊý¾Ý£¨È磺C1346£©
ÄÇô¹¤×÷±í1µÄA21Ò²ÒªµÈÓÚ¹¤×÷±í2µÄB1346
¹¤×÷±í2 µÄCÁеÄÊý¾ÝÅÓ´ó»ìÂÒ£¬²»ÖªµÀ¹¤×÷±í1µÄBÁÐijÐеÄÊý¾ÝÔÚ¹¤×÷±íµÄCÁÐÖеÄÄÄÐУ¬Õ⹦ÄÜÔõôŪ£¿

» ²ÂÄãϲ»¶

ÒÑÔÄ   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

quangel

ľ³æ (ÕýʽдÊÖ)

VBA±à³Ì²éÕÒ
×µÄ·½·¨£º
½«¹¤×÷±í1°´BÁÐÅÅÐò£¬½«¹¤×÷±í2°´CÅÅÐò£¬È»ºó¶Ô±È
2Â¥2009-02-06 13:42:17
ÒÑÔÄ   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

zhaozheng522

½ð³æ (СÓÐÃûÆø)

²»ÊÇÊý×Ö£¬ÊÇ·ûºÅ£¡£¡
3Â¥2009-02-06 14:35:03
ÒÑÔÄ   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

lgm19851116

ľ³æ (ÕýʽдÊÖ)

Çå¾²µÄÅ®º¢

¡ï ¡ï
zhaozheng522(½ð±Ò+2,VIP+0):ллÄúµÄ»Ø´ð£¡¿ÉÄÜÎÒû˵Çå³þ 2-8 12:02
1¡¢¼ÙÈ繤×÷±í1µÄBÁÐÖÐijÐÐÊý¾Ý£¨Èç:B21£©µÈÓÚÔÚ¹¤×÷±í2 µÄCÁÐÖеÄijÐÐÊý¾Ý£¨È磺C1346£©
ÄÇô¹¤×÷±í1µÄA21Ò²ÒªµÈÓÚ¹¤×÷±í2µÄB1346
2¡¢¹¤×÷±í2 µÄCÁеÄÊý¾ÝÅÓ´ó»ìÂÒ£¬²»ÖªµÀ¹¤×÷±í1µÄBÁÐijÐеÄÊý¾ÝÔÚ¹¤×÷±íµÄCÁÐÖеÄÄÄÐУ¬Õ⹦ÄÜÔõôŪ£¿


»Ø1£ºÔÚ¹¤×÷±í1µÄA21ÖÐÊäÈ룺=if(B21=sheet!2C1346,sheet!2B1346,)
»Ø2£ºµ½¹¤×÷±í2µÄCÁÐËÑË÷һϣ¡
×ðÖØÉí±ßµÄÿһ¸öÈË£¬¾¡×Ô¼ºËùÄܰïÖú±ðÈË£¡Î¢Ð¦µÄÃæ¶ÔÒ»ÇУ¬ÒÔÆ½³£ÐĶԴýËùÓеÄÊÂÇ飡ӵÓÐÒ»¿Å¸Ð¶÷µÄÐÄ£¡
4Â¥2009-02-06 17:39:20
ÒÑÔÄ   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

zhaozheng522

½ð³æ (СÓÐÃûÆø)

¿ÉÄÜÎÒûÃèÊöÇå³þ£¬µÚÒ»¸÷ÎÊÌâÓëµÚ¶þ¸öÎÊÌâÊÇͬһ¸öÎÊÌâµÄ£¡
5Â¥2009-02-08 13:12:18
ÒÑÔÄ   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

eb00k

Í­³æ (³õÈëÎÄ̳)

¡ï ¡ï
zhaozheng522(½ð±Ò+2,VIP+0):Äâ˵¶ÔÁË£¬ºóÃæÈ·Êµ¾ÍÓÃÕ⹦ÄÜʵÏֵģ¬Ð»Ð» 3-2 13:26
vlookup
6Â¥2009-02-13 10:13:23
ÒÑÔÄ   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

bloon

½ð³æ (СÓÐÃûÆø)

Áé»îÔËÓù«Ê½£¬ ¹ýÂË ¹¦ÄÜ
ºÃÏñÓиö¹«Ê½¿ÉÒÔ²éÕÒÁ½ÁÐÖ®¼ä¹²Í¬µÄÏîÄ¿
7Â¥2009-02-13 23:21:00
ÒÑÔÄ   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

fzbxxw

Ìú¸Ëľ³æ (ÖøÃûдÊÖ)

Èç¹ûÊÇÓÃÀÏÊóÖ±½ÓÀ­µÄ£¬ÄÇô¶¼»áÒ»Ò»¶ÔÓ¦¡£×¢Òâ²é±íÒ»ÖеĹ«Ê½£¬Ò»¿´¾ÍÃ÷°×ÁË¡£
8Â¥2009-02-13 23:59:23
ÒÑÔÄ   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

wzd0604

½ð³æ (ÕýʽдÊÖ)

ÎÒˮƽ̫µÍ£¬¿´²»¶®Â¥Ö÷˵µÄÄÚÈÝ¡£
µ±Äê·²¸ßµÄÏòÈÕ¿ûÁ¬Ò»¸öÍÁ¶¹¶¼»»²»À´£¬¿ÉÏÖÈç½ñ°ÑÈ«ÊÀ½çµÄÍÁ¶¹ÄÃÀ´Ò²¶¥²»ÉÏÈ˼ÒһƬ»¨°ê£¡
9Â¥2009-02-14 10:22:00
ÒÑÔÄ   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

stephenking

ÔÚ¹¤×÷±í1µÄA21ÖÐÊäÈ룺=if(B21=sheet!2C1346,sheet!2B1346,)
µ½¹¤×÷±í2µÄCÁÐËÑË÷һϣ¡
10Â¥2009-02-14 10:56:25
ÒÑÔÄ   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû
Ïà¹Ø°æ¿éÌø×ª ÎÒÒª¶©ÔÄÂ¥Ö÷ zhaozheng522 µÄÖ÷Ìâ¸üÐÂ
×î¾ßÈËÆøÈÈÌûÍÆ¼ö [²é¿´È«²¿] ×÷Õß »Ø/¿´ ×îºó·¢±í
[¿¼ÑÐ] 309·Ö085801Çóµ÷¼Á +3 ѧԱGtwj7W 2026-03-31 3/150 2026-03-31 19:41 by Wang200018
[¿¼ÑÐ] Ò»Ö¾Ô¸»ª¶«Àí¹¤´óѧ£¬080500ѧ˶£¬317·Ö£¬Çóµ÷¼Á +9 s1145 2026-03-31 9/450 2026-03-31 18:47 by JourneyLucky
[¿¼ÑÐ] 308Çóµ÷¼Á +11 īīĮ 2026-03-25 11/550 2026-03-31 17:54 by Î޼ʵIJÝÔ­
[¿¼ÑÐ] 086000ÉúÎïÓëÒ½Ò© ³õÊÔ274Çóµ÷¼Á +4 С¶£µ±À´ÁË 2026-03-30 4/200 2026-03-31 16:48 by shengliu165
[¿¼ÑÐ] 330·ÖÇóµ÷¼Á +6 qzenlc 2026-03-29 6/300 2026-03-31 16:44 by Wang200018
[¿¼ÑÐ] 322Çóµ÷¼Á +3 ìäÙÒXX 2026-03-31 3/150 2026-03-31 16:32 by ¼Çʱ¾2026
[¿¼ÑÐ] ÉúÎïѧ 296 Çóµ÷¼Á +7 ¶ä¶ä- 2026-03-26 9/450 2026-03-31 14:26 by jp9609
[¿¼ÑÐ] 287Çóµ÷¼Á +17 land xuxu 2026-03-26 17/850 2026-03-31 11:16 by Zzxxxs
[¿¼ÑÐ] 085600²ÄÁÏÓ뻯¹¤µ÷¼Á +16 kikiki7 2026-03-30 16/800 2026-03-31 10:03 by ÂÈ»¯ÑÇÏõõ£
[¿¼ÑÐ] 085602 »¯Ñ§¹¤³Ìר˶ 340·ÖÇóµ÷¼Á +4 qianbai11 2026-03-29 4/200 2026-03-30 11:34 by ÌÆãå¶ù
[¿¼ÑÐ] Çóµ÷¼Á +10 ÕÅzz111 2026-03-27 11/550 2026-03-30 09:17 by Î޼ʵIJÝÔ­
[¿¼ÑÐ] Ò»Ö¾Ô¸±±¾©¹¤Òµ´óѧ£¬324·ÖÇóµ÷¼Á +6 Áã°Ë# 2026-03-28 6/300 2026-03-29 21:20 by nanaliuyun
[¿¼ÑÐ] 275Çóµ÷¼Á +15 Micky11223 2026-03-25 20/1000 2026-03-29 20:44 by ÌÆãå¶ù
[¿¼ÑÐ] 349Çóµ÷¼Á +6 Àîľ×Ó°¡¹þ¹þ 2026-03-25 6/300 2026-03-29 12:47 by Î޼ʵIJÝÔ­
[¿¼ÑÐ] 356Çóµ÷¼Á +4 gysy?s?a 2026-03-28 4/200 2026-03-29 10:32 by ÌÆãå¶ù
[¿¼ÑÐ] Çóµ÷¼Á +7 ÕùÈ¡¾Åµã˯ 2026-03-28 8/400 2026-03-28 21:07 by ÕùÈ¡¾Åµã˯
[¿¼ÑÐ] 286Çóµ÷¼Á +12 PolarBear11 2026-03-26 12/600 2026-03-28 12:14 by zllcz
[¿¼ÑÐ] 292Çóµ÷¼Á +14 ¶ì¶ì¶ì¶î¶î¶î¶î¶ 2026-03-25 15/750 2026-03-28 08:45 by WYUMater
[¿¼ÑÐ] 275Çóµ÷¼Á +10 jjjjjjjjjjl 2026-03-27 10/500 2026-03-27 23:47 by barnett0632
[¿¼ÑÐ] 298µ÷¼Á +3 jiyingjie123 2026-03-27 3/150 2026-03-27 11:57 by wxiongid
ÐÅÏ¢Ìáʾ
ÇëÌî´¦ÀíÒâ¼û