±±¾©Ê¯ÓÍ»¯¹¤Ñ§Ôº2026ÄêÑо¿ÉúÕÐÉú½ÓÊÕµ÷¼Á¹«¸æ
²é¿´: 1156  |  »Ø¸´: 10
µ±Ç°Ö»ÏÔʾÂú×ãÖ¸¶¨Ìõ¼þµÄ»ØÌû£¬µã»÷ÕâÀï²é¿´±¾»°ÌâµÄËùÓлØÌû

°¢Q210

гæ (СÓÐÃûÆø)

[ÇóÖú] ExcelÖÐÔõôʵÏÖÊý¾Ýת»¯£¿

ÊÇÕâÑùµÄ£¬ÒÑÖªÊý¾ÝҪͨ¹ýת»»±íת³É¿É¼ÆËãÊý¾Ý£¨¾ÍÊǰٷÖÂÊÓë¸ÅÂʵ¥Î»»»Ëã±í£©£¬ÓÃʲô¹ý³Ì¿ÉÒÔʵÏÖÊäÈëÒÑÖªÊý¾ÝºóÔÚÏÂÒ»¿òÖе¯³ö¿É¼ÆËãÊý¾Ý¡£ÓÐÈË˵ÓÃvlookup¿ÉÒÔʵÏÖ£¬²»¹ýÎÒûÓÐŪ³öÀ´£¬ÓÐûÓÐÈË¿ÉÒÔ°ïÎÒ¿´¿´£¬°ÝÍаÝÍÐ~~

ExcelÖÐÔõôʵÏÖÊý¾Ýת»¯£¿
104104deif8nfinf68ie6n.jpg
»Ø¸´´ËÂ¥

» ²ÂÄãϲ»¶

» ±¾Ö÷ÌâÏà¹Ø¼ÛÖµÌùÍÆ¼ö£¬¶ÔÄúͬÑùÓаïÖú:

Ïë±ÏÒµ£¬È¥¹¤×÷£¡£¡£¡
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

°¢Q210

гæ (СÓÐÃûÆø)

Ëͺ컨һ¶ä
ÒýÓûØÌû:
4Â¥: Originally posted by muguam at 2014-10-18 08:54:29
excelʵÏÖ¼ÆËã¶¼ÐèÒª²åÈ빫ʽ¡£
vlookup¹«Ê½Êǰ´ÁвéÕÒ£¬×îÖÕ·µ»Ø¸ÃÁÐËùÐè²éѯÁÐÐòËù¶ÔÓ¦µÄÖµ¡£

лл~~
Ïë±ÏÒµ£¬È¥¹¤×÷£¡£¡£¡
6Â¥2014-10-19 15:25:23
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû
²é¿´È«²¿ 11 ¸ö»Ø´ð

peterrjp

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

¡¾´ð°¸¡¿Ó¦Öú»ØÌû

Â¥Ö÷¿ÉÒÔ½²Çå³þÕâÁ½Áе½µ×ÓÐʲô¹ØÏµÂð£¿ÊDz»ÊǵÚÒ»ÁÐÇóºÍºó£¬µÚÒ»ÁеÄÿ¸öÊý×Ö³ýÒÔ×ܺ͵õ½µÄ°Ù·Ö±È£¨¸Ð¾õÕâÁ½Áв»³É±ÈÀý°¡£©£¿
2Â¥2014-10-17 15:55:43
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

bbqlhb

ľ³æ (СÓÐÃûÆø)

¡¾´ð°¸¡¿Ó¦Öú»ØÌû

¿´²»¶®ÄãÏë±í´ïʲô£¬ÖÁÓÚÄãÏë˵
¡°ÊµÏÖÊäÈëÒÑÖªÊý¾ÝºóÔÚÏÂÒ»¿òÖе¯³ö¿É¼ÆËãÊý¾Ý¡±
excelÀïµÄ¹«Ê½´úÈ룬Èç¹ûûÓУ¬¾Í×Ô¼ºÊäÈ빫ʽ£¬ÆäËûÐж¼ÓÃÕâ¸ö¹«Ê½¾ÍºÃ

» ±¾ÌûÒÑ»ñµÃµÄºì»¨£¨×îÐÂ10¶ä£©

3Â¥2014-10-17 16:04:18
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

muguam

ľ³æ (ÕýʽдÊÖ)

¡¾´ð°¸¡¿Ó¦Öú»ØÌû

excelʵÏÖ¼ÆËã¶¼ÐèÒª²åÈ빫ʽ¡£
vlookup¹«Ê½Êǰ´ÁвéÕÒ£¬×îÖÕ·µ»Ø¸ÃÁÐËùÐè²éѯÁÐÐòËù¶ÔÓ¦µÄÖµ¡£

» ±¾ÌûÒÑ»ñµÃµÄºì»¨£¨×îÐÂ10¶ä£©

ÔÙ¶à¼á³ÖÒ»Ã룡
4Â¥2014-10-18 08:54:29
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû
×î¾ßÈËÆøÈÈÌûÍÆ¼ö [²é¿´È«²¿] ×÷Õß »Ø/¿´ ×îºó·¢±í
[¿¼ÑÐ] 265Çóµ÷¼Á11408 +3 ÁõС¹lu 2026-03-27 3/150 2026-03-27 20:53 by nihaoar
[¿¼ÑÐ] 315·ÖÇóµ÷¼Á +6 26¿¼ÑÐÉϰ¶°æ26 2026-03-26 6/300 2026-03-27 19:54 by WYUMater
[¿¼ÑÐ] ²ÄÁÏÓ뻯¹¤£¨0856£©304ÇóBÇøµ÷¼Á +7 Çñgl 2026-03-27 7/350 2026-03-27 15:27 by JoeÂÊ
[¿¼ÑÐ] 339Çóµ÷¼Á +4 ¿¾ÂóÑ¿ 2026-03-27 5/250 2026-03-27 13:23 by 752105528
[¿¼ÑÐ] Çóµ÷¼Á323²ÄÁÏÓ뻯¹¤ +7 1124361 2026-03-24 7/350 2026-03-27 10:22 by wangjy2002
[¿¼ÑÐ] ²ÄÁÏѧ˶333Çóµ÷¼Á +8 ±±µÀÏï 2026-03-24 8/400 2026-03-27 10:18 by ÎÒÊÇС¿µ
[¿¼ÑÐ] Ò»Ö¾Ô¸ÉÂʦ´óÉúÎïѧ071000£¬298·Ö£¬Çóµ÷¼Á +5 SYA£¡ 2026-03-23 5/250 2026-03-27 09:29 by ²»³Ôô~µÄ؈
[¿¼ÑÐ] ²ÄÁϵ÷¼Á +8 Æ¥¿Ëi 2026-03-23 8/400 2026-03-27 08:11 by hypershenger
[¿¼ÑÐ] Ò»Ö¾Ô¸Î人Àí¹¤£¬×Ü·Ö321£¬Ó¢Ò»Êý¶þ£¬ÇóÀÏʦÊÕÁô¡£ +5 nnnnnnn5 2026-03-25 5/250 2026-03-27 04:42 by wxiongid
[¿¼ÑÐ] ²ÄÁÏÓ뻯¹¤304ÇóBÇøµ÷¼Á +3 Çñgl 2026-03-26 6/300 2026-03-26 18:03 by Çñgl
[¿¼ÑÐ] 334·Ö Ò»Ö¾Ô¸ÎäÀí ²ÄÁÏÇóµ÷¼Á +4 ÀîÀî²»·þÊä 2026-03-26 4/200 2026-03-26 16:00 by ²»³Ôô~µÄ؈
[¿¼ÑÐ] ²ÄÁÏ¿ÆÑ§Ó빤³Ì 317Çóµ÷¼Á +4 JKSOIID 2026-03-26 4/200 2026-03-26 15:58 by ²»³Ôô~µÄ؈
[¿¼ÑÐ] ×ÊÔ´Óë»·¾³ µ÷¼ÁÉêÇë(333·Ö) +9 holy J 2026-03-21 9/450 2026-03-26 15:47 by 161765490
[¿¼ÑÐ] Ò»Ö¾Ô¸ºÓ¹¤´ó 081700 276Çóµ÷¼Á +4 µØÇòÈÆ×ÅÌ«Ñôת 2026-03-23 4/200 2026-03-26 14:27 by zzll406
[¿¼ÑÐ] 291 Çóµ÷¼Á +7 »¯¹¤2026½ì±ÏÒµÉ 2026-03-21 8/400 2026-03-26 11:25 by AlenQIN.
[¿¼ÑÐ] 299Çóµ÷¼Á +4 15188958825 2026-03-25 4/200 2026-03-25 22:56 by 418490947
[¿¼ÑÐ] ÍøÂç¿Õ¼ä°²È«0839Õе÷¼Á +4 w320357296 2026-03-25 6/300 2026-03-25 17:59 by 255671
[¿¼ÑÐ] »¯Ñ§µ÷¼Á +6 yzysaa 2026-03-21 6/300 2026-03-25 09:27 by aa331100
[¿¼ÑÐ] 291Çóµ÷¼Á +3 HanBeiNingZC 2026-03-24 3/150 2026-03-24 16:34 by barlinike
[¿¼ÑÐ] 284Çóµ÷¼Á +3 yanzhixue111 2026-03-23 6/300 2026-03-23 22:58 by pswait
ÐÅÏ¢Ìáʾ
ÇëÌî´¦ÀíÒâ¼û