[µo°Ý]¨Ï¥Îvlookup©Ô¤£¨ì¤£¦P¤u§@ªíªº¸ê®Æ
- ©«¤l
- 14
- ¥DÃD
- 2
- ºëµØ
- 0
- ¿n¤À
- 69
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-12-19
- ³Ì«áµn¿ý
- 2016-6-29
|
[µo°Ý]¨Ï¥Îvlookup©Ô¤£¨ì¤£¦P¤u§@ªíªº¸ê®Æ
ªþ¥ó¸ÑÀ£ÁY«á¦³¤GÓexcel..
"¸ê®Æªí"¬O¤§«e¬Ý¨ìª©¤W¬Y¦ì¤j¤jªþ¤Wªº¡A¦b¼gvlookupªº½d³ò®É¬O¥i¥H¤£¥Îkey¤JA,B,CÄ檺¶Ü!? 0.0?
"¸ê®Æªí 02"¬O°ÝÃD©Ò¦b...¬°¤°»ò¥Î¦P¼Ëªº¤è¦¡¼g¤JÀx¦s®æ½TÅã¥Ü¿ù»~!?
¦bªí02¤º¡A"°ò·Ç"ªí®æ¬O«Ø¦nªº¸ê®Æ¡A·Qn¦b"ªÅ¥Õ"ªí®æªº¶Â®Ø³Ì¤W¤è¤@®æ¿é¤J"°ò·Ç"¤¤ªº¨ä¤¤¤@Ó°Ó«~¦W¡A¦b"ªÅ¥Õ"ªº¾AÀ³¯g¤Î°Æ§@¥Î·|¦Û°Ê±a¤J¸ê®Æ¡A
°Ñ·Ó¤F¥ý«e¤@¦ì¤j¤jªº¼gªk¡A¥i¬O¦æ¤£³q..
³Â·Ð¦U¦ì°ª¤â¤j¤jÀ°¦£¸ÑÓ´b..ÁÂÁ |
-
-
test.rar
(9.41 KB)
|
¡¸¡ã¶W¹à·s¤â¡ã¡¸
¥Ø«e¥u·|SUM,IF,COUNTIF..
~~§V¤O¾Ç²ß¤¤~~
|
|
|
|
|
- ©«¤l
- 14
- ¥DÃD
- 2
- ºëµØ
- 0
- ¿n¤À
- 104
- ÂI¦W
- 0
- §@·~¨t²Î
- OFFICE2000
- ³nÅ骩¥»
- OFFICE2000
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- ¨Ó¦Û
- °ª¶¯
- µù¥U®É¶¡
- 2010-12-29
- ³Ì«áµn¿ý
- 2018-5-18
|
§ï¦¨=IF(ISBLANK(A1),"",VLOOKUP(A1,°ò·Ç!B1:E14,3,0))´N¥i¥H¤F |
|
|
|
|
|
|
- ©«¤l
- 14
- ¥DÃD
- 2
- ºëµØ
- 0
- ¿n¤À
- 69
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-12-19
- ³Ì«áµn¿ý
- 2016-6-29
|
ÁÂÁ¦t¶ýªºÀ°¦£¡A·P®¦
¦ý¯u¬O¥X¥G§Úªº·N®Æ¤§¥~..¥u¬O±NA§ï¦¨B..¸Õ¤F¤@¤Ñ´N¬O¨S¦³·Q¨ì§ï¦¨B ~"~
¥t¤@Ó°ÝÃD...
¦pªGÄæ¦ìA,B,C...¤£¥´¥X¨Óªº¸Ü¡A¤@¼Ë¥i¥H·j´Mªº¨ì¸ê®Æ¶Ü!?
ÁÂÁÂ |
|
¡¸¡ã¶W¹à·s¤â¡ã¡¸
¥Ø«e¥u·|SUM,IF,COUNTIF..
~~§V¤O¾Ç²ß¤¤~~
|
|
|
|
|
- ©«¤l
- 31
- ¥DÃD
- 3
- ºëµØ
- 0
- ¿n¤À
- 74
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN7
- ³nÅ骩¥»
- OFFICE2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2011-3-29
- ³Ì«áµn¿ý
- 2014-4-10
|
¥»©«³Ì«á¥Ñ ann ©ó 2011-4-16 01:56 ½s¿è
[img]
[/img]
vlookup¬O¦b³Ì¥ªÄæ´M§ä
±zªº°Ó«~¦WºÙ¬O©ñ¦bBÄæ
©Ò¥Hn±NBÄæ·í³Ì¥ªÄæ |
|
Ann
|
|
|
|
|
- ©«¤l
- 248
- ¥DÃD
- 55
- ºëµØ
- 0
- ¿n¤À
- 334
- ÂI¦W
- 0
- §@·~¨t²Î
- xp
- ³nÅ骩¥»
- 2003
- ¾\ŪÅv
- 20
- µù¥U®É¶¡
- 2010-7-24
- ³Ì«áµn¿ý
- 2023-2-2
|
¥»©«³Ì«á¥Ñ 317 ©ó 2011-4-16 07:52 ½s¿è
ISBLANK¬OÅÞ¿è¨ç¼Æ, ·íÀx¦s¬OªÅ¥Õ®É¶Ç¦^TRUE, ¦pªG¦³È®É«h¶Ç¦^FALSE,
IF(ISBLANK(A1),"",¤j¤j¥i¥H¤F¸Ñ¨ç¼Æ§À,"", ³o¬O·íÀx¦s®æ¬OªÅ®É«h¶Ç¦^Àx¦sªÅ¥Õ,
¤j¤j¥i¥H§â³o±ø¨ç¼Æ§R°£, ¬Ý¬Ý®ÄªG, ¶Ç¦^«h¬ON/A, ³o·|°µ¦¨ªí®æ¤£¬üÆ[, ¦Ó¤Wz两±ø
¨ç¼Æ°t¦X,«h¬O´_¦X¹B¥Î... |
|
|
|
|
|
|
- ©«¤l
- 14
- ¥DÃD
- 2
- ºëµØ
- 0
- ¿n¤À
- 69
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-12-19
- ³Ì«áµn¿ý
- 2016-6-29
|
¥»©«³Ì«á¥Ñ cck8x8 ©ó 2011-4-16 11:22 ½s¿è
·PÁÂann¤j¤jªº¸Ñ»¡ ^^
ISBLANK¬OÅÞ¿è¨ç¼Æ, ·íÀx¦s¬OªÅ¥Õ®É¶Ç¦^TRUE, ¦pªG¦³È®É«h¶Ç¦^FALSE,
IF(ISBLANK(A1),"",¤j¤j¥i¥H¤F¸Ñ¨ç¼Æ§À,"", ³o¬O·íÀx¦s®æ¬OªÅ®É«h¶Ç¦^Àx¦sªÅ¥Õ,
¤j¤j¥i¥H§â³o±ø¨ç¼Æ§R°£, ¬Ý¬Ý®ÄªG, ¶Ç¦^«h¬ON/A, ³o·|°µ¦¨ªí®æ¤£¬üÆ[, ¦Ó¤Wz两±ø
¨ç¼Æ°t¦X,«h¬O´_¦X¹B¥Î...
¥»¨Ó¤]ı±o©_©Ç¡A¬°¤°»òn¦h¦¹¤@Á|ªº¡A²{¦b²×©óª¾¹D¤F
ÁÂÁ¤j¤jªº¸Ñ»¡ |
|
¡¸¡ã¶W¹à·s¤â¡ã¡¸
¥Ø«e¥u·|SUM,IF,COUNTIF..
~~§V¤O¾Ç²ß¤¤~~
|
|
|
|
|
- ©«¤l
- 455
- ¥DÃD
- 8
- ºëµØ
- 1
- ¿n¤À
- 480
- ÂI¦W
- 0
- §@·~¨t²Î
- WINS home
- ³nÅ骩¥»
- OFFICE XP
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥Âí
- µù¥U®É¶¡
- 2010-5-1
- ³Ì«áµn¿ý
- 2015-1-22
|
«Øij§ï³o¼Ë
=IF(COUNTIF(°ò·Ç!B:B,A1),VLOOKUP(A1,°ò·Ç!B1:E14,3,0),"") |
|
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I
|
|
|
|
|
- ©«¤l
- 455
- ¥DÃD
- 8
- ºëµØ
- 1
- ¿n¤À
- 480
- ÂI¦W
- 0
- §@·~¨t²Î
- WINS home
- ³nÅ骩¥»
- OFFICE XP
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥Âí
- µù¥U®É¶¡
- 2010-5-1
- ³Ì«áµn¿ý
- 2015-1-22
|
IF(ISBLANK(A1),"",VLOOKUP(A1,°ò·Ç!B1:E14,3,0))
¥u¹ïa1§PÂ_¬O§_ªÅ¥Õ,¤£ºÞ¦b°ò·Ç!B:B¬O§_¦³a1¬Û¦PÈ¥i¨Ñ¹ï·Ó,ÁÙ¬O·|²£¥Í¿ù»~È
¥H¤W¥u¬O«Øij¤]«Dµ´¹ï
¥Îif(iserror(vlookup(....)),"",vlookup(....))·N«ä¬Û¦P |
-
-
Book1.rar
(1.72 KB)
|
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I
|
|
|
|
|