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

[µo°Ý]¨Ï¥Îvlookup©Ô¤£¨ì¤£¦P¤u§@ªíªº¸ê®Æ

[µ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·Q­n¦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¾Ç²ß¤¤~~

§ï¦¨=IF(ISBLANK(A1),"",VLOOKUP(A1,°ò·Ç!B1:E14,3,0))´N¥i¥H¤F

TOP


ÁÂÁ¦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¾Ç²ß¤¤~~

TOP

¥»©«³Ì«á¥Ñ ann ©ó 2011-4-16 01:56 ½s¿è

[img] [/img]
vlookup¬O¦b³Ì¥ªÄæ´M§ä
±zªº°Ó«~¦WºÙ¬O©ñ¦bBÄæ
©Ò¥H­n±NBÄæ·í³Ì¥ªÄæ
Ann

TOP

§ï¦¨=IF(ISBLANK(A1),"",VLOOKUP(A1,°ò·Ç!B1:E14,3,0))´N¥i¥H¤F
¦t¶ý µoªí©ó 2011-4-14 15:06



   
½Ð°Ý, ¦pªG¥u¥Î
=VLOOKUP(A1,°ò·Ç!B1:E14,3,0)
¤]¥i¥H§ä±o¨ì

¬°¦óÁÙ­n¥[¤J³o ISBLANK ¨ç¼Æ©O¡H
¦³¤°»ò¥Î·N¡H

TOP

¥»©«³Ì«á¥Ñ 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·|°µ¦¨ªí®æ¤£¬üÆ[, ¦Ó¤W­z两±ø
¨ç¼Æ°t¦X,«h¬O´_¦X¹B¥Î...

TOP

¥»©«³Ì«á¥Ñ 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·|°µ¦¨ªí®æ¤£¬üÆ[, ¦Ó¤W­z两±ø
¨ç¼Æ°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¾Ç²ß¤¤~~

TOP

«Øij§ï³o¼Ë
=IF(COUNTIF(°ò·Ç!B:B,A1),VLOOKUP(A1,°ò·Ç!B1:E14,3,0),"")
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

«Øij§ï³o¼Ë
=IF(COUNTIF(°ò·Ç!B:B,A1),VLOOKUP(A1,°ò·Ç!B1:E14,3,0),"")
gong µoªí©ó 2011-4-16 18:28



   
½Ð°Ý gong ª©¤j
¬°¦ó­n§ï¬°³o¼Ë¡H
§ï¬°³o¼Ë¦³¦ó¨ä¥L¥Î·N©O¡H
ÁÂÁ¡I

TOP

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

TOP

        ÀR«ä¦Û¦b : ¤H¨ÆªºÁ}Ãø»PµZ¿i¡A´N¬O¤@ºØ¦ÒÅç¡C
ªð¦^¦Cªí ¤W¤@¥DÃD