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

VLOOKUP¤¤#NA°ÝÃD½Ð±Ð

VLOOKUP¤¤#NA°ÝÃD½Ð±Ð

¦U¦ì¤j¤j¡G
ªþÀɤ¤ªº¸Õºâ¤¤HÄæ¤@ª½¥X²{#NA¥B§ä¤£¨ì­È¬°¦ó¡HIF(C3="","",VLOOKUP(C3,¸ê®Æ!$A$1:$Q$41,6,0))
§Æ±æ¤ä«ù!

¤W­±¡A
¸É¤WªþÀÉ!

°ÝÃD19.rar (13.96 KB)

§Æ±æ¤ä«ù!

TOP

¦^´_ 2# s7659109


    =IF(C2="","",IF(ISNA(VLOOKUP(C2,¸ê®Æ!A:Q,6,0)),"",VLOOKUP(C2,¸ê®Æ!A:Q,6,0)))

na¥Nªí§ä¤£¨ì¸ê®Æ

½Ð¥Î³o¤½¦¡¬Ý¬Ý¡I
ÁÂÁ¡I
·s¤H¤@ªT

TOP

¤j¤j¡G
N/A¬O¸Ñ¨M¤F¡A¦ý½T§ä¤£¨ì­È¡A¬°¦ó¡H

°ÝÃD19-1.rar (14.17 KB)

§Æ±æ¤ä«ù!

TOP

¦^´_ 4# s7659109

«Øij¦b¸ê®Æ¤u§@­¶ªºAÄæ¤Î¸Õºâ¤u§@­¶ªºCÄæ¦ì¥H¸ê®Æ­åªR¤@¤U´N¥i¥H¤F¡I
·s¤H¤@ªT

TOP

¤j¤j¡G
¸ê®Æ¸Ñ­å¡A¤@¼Ë®»¤£¨ì­È¡C

°ÝÃD19-2.rar (14.46 KB)

§Æ±æ¤ä«ù!

TOP

¤j¤j¡G
¥t¦³¤@°ÝÃD½Ð±Ð¡A¦³¤H³o»ò»¡¡Avlookup¥u¦³²Ä¤@Äæ¤~¯à°_§@¥Î¡A¦]¥»ÃD¸ê®Æ­¶¬°²Ä4Äæ¡A¬G°_¤£¤F°µ¥Î¡A¬O³o¼Ë¶Ü¡A­Y¹ï·Ó¸ê®Æ»Ý­n¥Î¨ì¦n´XÄ檺¯Á¤Þ¸ê®Æ¡A¨º»ò¬O¤£¬O¶}¦n´X­Ó¤u§@­¶¡C
§Æ±æ¤ä«ù!

TOP

¦^´_ 6# s7659109

=IF(C2="","",IFERROR(VLOOKUP(C2,¸ê®Æ!D:Q,3,0),""))
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¤j¤j¡G





¥t¦³¤@°ÝÃD½Ð±Ð¡A¦³¤H³o»ò»¡¡Avlookup¥u¦³²Ä¤@Äæ¤~¯à°_§@¥Î¡A¦]¥»ÃD¸ê®Æ­¶¬°²Ä4Äæ¡A¬G°_¤£¤F°µ¥Î¡A ...
s7659109 µoªí©ó 2014-3-19 21:51



¤£ª¾¹Dªþ¥ó³o¼Ë¬O¤£¬O§A­nªº¡I§A¬Ý¤@¤U¡I
table_arrayÀ³¸Ó¥HÄæ¦ì¤è¦¡¿ï¨ú¡]¨Ò¦pA:QÄæ¡A©ÎB:JÄæ¡A¦Û¤v¨M©w¸ê®Æ±q­þÄæ¦ì¶}©lºâ°_¡^
©êºp¡A¤£ª¾¹D³o¼Ë»¡¦³¨S¦³À°¨ì§A¡I
·s¤H¤@ªT

TOP

¦^´_ 7# s7659109
®Ú¾Úexcelªºhelp¤¤¼gªº(¤U¤è¬õ¦â³¡¥÷)
À³¸Ó¬O»Ý­n¦b²Ä¤@Äæ

VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)
Lookup_value    ¦bªí®æ°}¦C (°}¦C:¥Î¨Ó«Ø¥ß²£¥Í¦h­Óµ²ªG©Î¹Bºâ¤@²Õ¥H¦C¤ÎÄæ±Æ¦C¤§¤Þ¼Æªº³æ¤@¤½¦¡¡C°}¦C½d³ò¦@¥Î¤@­Ó¤½¦¡¡F¤@­Ó°}¦C±`¼Æ¬O¥Î§@¤@­Ó¤Þ¼Æªº¤@²Õ±`¼Æ¡C)ªº²Ä¤@Ä椤·j´Mªº¼Æ­ÈLookup_value ¥i¥H¬O¼Æ­È¡A¤]¥i¥H¬O°Ñ·Ó¦ì§}¡C·í lookup_value ¤p©ó table_array ²Ä¤@Ä椤ªº³Ì¤p­È®É¡AVLOOKUP ±N·|¶Ç¦^¿ù»~­È #N/A¡C
Table_array    ¨âÄæ¥H¤Wªº¸ê®Æ¡C½Ð¨Ï¥Î°Ñ·Ó¦ì§}¨Ó«ü¦V¬Y­Ó½d³ò©Î½d³ò¦WºÙ¡Ctable_array ²Ä¤@Ä椤ªº­È§Y¬° lookup_value ©Ò·j´Mªº­È¡C³o¨Ç­È¥i¥H¬O¤å¦r¡B¼Æ¦r©ÎÅÞ¿è­È (¤£¤À¤j¤p¼g)¡C
°Ê©À¦¨¦]¿n¦]¦¨ªG by huijuang

TOP

        ÀR«ä¦Û¦b : ¤£­n¤p¬Ý¦Û¤v¡A¦]¬°¤H¦³µL­­ªº¥i¯à¡C
ªð¦^¦Cªí ¤W¤@¥DÃD