±±¾©Ê¯ÓÍ»¯¹¤Ñ§Ôº2026ÄêÑо¿ÉúÕÐÉú½ÓÊÕµ÷¼Á¹«¸æ
²é¿´: 725  |  »Ø¸´: 3

mike880102

½ð³æ (ÖøÃûдÊÖ)

[ÇóÖú] ÇóExcel¸ßÊÖ°ï°ïæ~~¹ØÓÚº¯Êý ÒÑÓÐ2È˲ÎÓë

ҪʵÏÖÈçϹ¦ÄÜ£ºµ±A3£ºA8ÖеÄijһֵµÈÓÚD3ʱ(´ËÀýÖÐΪA6)£¬E3µÈÓÚA6ºóµ¥Ôª¸ñµÄÖµ£¬¼´¡°B6¡±¡£Çë´óÉñÖ¸µ¼£¡Ð»Ð»~

ÇóExcel¸ßÊÖ°ï°ïæ~~¹ØÓÚº¯Êý
²¶»ñ.JPG
»Ø¸´´ËÂ¥

» ²ÂÄãϲ»¶

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

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

cooooldog

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

ส็็็

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

¸Ðл²ÎÓ룬ӦÖúÖ¸Êý +1
ÍøÉÏ¿´vlookup º¯ÊýµÄÀý×Ó,
ÓÐÏֳɵÄÀý×ÓÓÃ

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

ส็็็็็็็็็็็็็็็็็็็็
2Â¥2014-08-28 13:43:21
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

qinglanzhang

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

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

¡ï ¡ï ¡ï ¡ï ¡ï ¡ï ¡ï ¡ï ¡ï ¡ï ¡ï
¸Ðл²ÎÓ룬ӦÖúÖ¸Êý +1
jjdg: ½ð±Ò+1, ¸Ðл²ÎÓë 2014-08-29 23:02:55
mike880102: ½ð±Ò+10, ¡ï¡ï¡ï¡ï¡ï×î¼Ñ´ð°¸, ·Ç³£¸Ðл~~ 2014-08-30 09:59:01
ÔÚE3ÖÐÊäÈë¡°=vlookup(d3,a:b,2,false)¡±
3Â¥2014-08-28 14:48:31
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

mike880102

½ð³æ (ÖøÃûдÊÖ)

Ëͺ컨һ¶ä
ÒýÓûØÌû:
2Â¥: Originally posted by cooooldog at 2014-08-28 13:43:21
ÍøÉÏ¿´vlookup º¯ÊýµÄÀý×Ó,
ÓÐÏֳɵÄÀý×ÓÓÃ

лл~~ÕýÊǴ˺¯Êý
4Â¥2014-08-30 09:58:41
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû
Ïà¹Ø°æ¿éÌø×ª ÎÒÒª¶©ÔÄÂ¥Ö÷ mike880102 µÄÖ÷Ìâ¸üÐÂ
×î¾ßÈËÆøÈÈÌûÍÆ¼ö [²é¿´È«²¿] ×÷Õß »Ø/¿´ ×îºó·¢±í
[¿¼ÑÐ] ²ÄÁÏר˶283Çóµ÷¼Á +17 ÊÔÊÔ¿´ß 2026-04-04 18/900 2026-04-06 09:24 by 286640313
[¿¼ÑÐ] Çóµ÷¼Á +5 chenxrlkx 2026-04-05 7/350 2026-04-06 07:54 by houyaoxu
[¿¼ÑÐ] 331Çóµ÷¼Á +8 ÓÚÕ÷yz 2026-04-05 8/400 2026-04-06 00:54 by fmesaito
[¿¼ÑÐ] ²ÄÁϵ÷¼Á +14 Ò¼·¡·¡ÒÚ 2026-04-04 14/700 2026-04-05 23:31 by À´¿´Á÷ÐÇÓê10
[¿¼ÑÐ] ²ÄÁÏר˶322·Ö +10 ¹þ¹þ¹þºðºðºð¹þ 2026-04-04 10/500 2026-04-05 21:22 by ѧԱ8dgXkO
[¿¼ÑÐ] 280Çóµ÷¼Á +4 Àîrien 2026-04-04 4/200 2026-04-05 18:44 by imissbao
[¿¼ÑÐ] µ÷¼Á +5 ºÃºÃ¶ÁÊé¡£ 2026-04-01 5/250 2026-04-05 17:54 by liucky
[¿¼ÑÐ] 385·Ö ÉúÎïѧ£¨071000£©Çóµ÷¼Á +11 qf626 2026-04-01 11/550 2026-04-05 17:35 by Ecowxq666£¡
[¿¼ÑÐ] 284Çóµ÷¼Á +7 Ðìͬѧ_001 2026-04-04 13/650 2026-04-05 17:19 by yulian1987
[¿¼ÑÐ] ¿¼ÑÐÉúÎïѧ¿¼AÇø211£¬³õÊÔ322£¬¿ÆÄ¿Éú»¯ºÍÉúÎï×ۺϣ¬Çóµ÷¼Á +6 ¡£¡£¡£54 2026-04-03 6/300 2026-04-05 14:54 by JOKER0401
[¿¼ÑÐ] µ÷¼Á +3 ºÃºÃ¶ÁÊé¡£ 2026-04-02 3/150 2026-04-05 13:02 by arrow8852
[¿¼ÑÐ] Ò»Ö¾Ô¸ÎäÀí²ÄÁϹ¤³Ì302µ÷¼Á»·»¯»ò»¯¹¤ +19 Doleres 2026-03-31 20/1000 2026-04-04 16:44 by °¡¿¡£¡
[¿¼ÑÐ] 319Çóµ÷¼Á +4 ÐÇÐDz»Õ£ÑÛà¶ 2026-04-03 4/200 2026-04-04 16:25 by ÖзÉÔº¿Õ¹ÜѧԺÑ
[¿¼ÑÐ] ±¾¿Æ985£¬×¨Òµ0812·Ö336Çóµ÷¼Á +4 ĪĪºÜÐÐ 2026-04-03 4/200 2026-04-03 21:31 by zhq0425
[¿¼ÑÐ] 303Çóµ÷¼Á +9 DLkz1314. 2026-03-30 9/450 2026-04-03 18:34 by lsÁõ˧
[¿¼ÑÐ] 08¹¤¿Æ275·ÖÇóµ÷¼Á +14 AaAa7420 2026-03-31 14/700 2026-04-03 11:13 by cocolv
[¿¼ÑÐ] 085600£¬320·ÖÇóµ÷¼Á +6 ´ó²öС×Ó 2026-04-02 6/300 2026-04-02 21:54 by dongzh2009
[¿¼ÑÐ] 285Çóµ÷¼Á +14 AZMK 2026-04-02 14/700 2026-04-02 15:54 by ÉϾÅÌìÀ¿Ô£¨ºÃÔ
[¿¼ÑÐ] ²ÄÁÏ»¯¹¤340Çóµ÷¼Á +5 jhx777 2026-03-30 5/250 2026-04-02 12:45 by smileboy2006
[¿¼ÑÐ] ¼ª´óÉúÎïѧ326·ÖÇóµ÷¼Á +3 sunnyupup 2026-03-31 3/150 2026-03-31 09:28 by longlotian
ÐÅÏ¢Ìáʾ
ÇëÌî´¦ÀíÒâ¼û