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

VLOOKUP§ä¨ìªÅ¥Õ¸ê®Æ·|¥X¿ù

VLOOKUP§ä¨ìªÅ¥Õ¸ê®Æ·|¥X¿ù

VLOOKUP§ä¨ìªÅ¥Õ¸ê®Æ·|¥X¿ù

­n«ç»ò§ï¤~¤£·|Åãµø¿ùèk?
©Î¬OÅãµø "0"

test.rar (12.66 KB)

excel¾Ç²ß¤¤!¿v¥X¹Ú·Q
https://www.youtube.com/channel/UCPAiRNsHX3k_omp0YDgfDiA

¥»©«³Ì«á¥Ñ p212 ©ó 2014-11-14 12:40 ½s¿è

¦^´_ 1# kkooo15
¥HÀx¦s®æB3­ì¤½¦¡¬°¨Ò¡A½Ð­×§ï¬°
for Excel 2007/2013
=IFERROR(VLOOKUP(A3,­û¤u¸ê®Æ,2,FALSE),"")
for Excel 2003/2000
=IF(ISNA(VLOOKUP(A3,­û¤u¸ê®Æ,2,FALSE)),"",VLOOKUP(A3,­û¤u¸ê®Æ,2,FALSE))
½Ð°Ñ¦Ò¡I

TOP

¦^´_ 2# p212

ÁÂÁ¡A¥i¥H¤F~~
½Ð±Ð¤@¤U¬°¤°»ò·|³o¼Ë?
excel¾Ç²ß¤¤!¿v¥X¹Ú·Q
https://www.youtube.com/channel/UCPAiRNsHX3k_omp0YDgfDiA

TOP

¦^´_ 3# kkooo15


    §ä¤£¨ìªF¦èÅã¥ÜN/A¬O¨t²Î¹w³]ªº¡A©Ò¥H¤~­n¥[­Ó¤½¦¡¡yIFERROR¡z©Î¬O¡yISERROR¡BISNA¡z¨Ó§â¥LÁôÂð_¨Ó¡C

TOP

        ÀR«ä¦Û¦b : ¡i¥Í©R¦b©I§l¶¡¡j¦òªû»¡¡G¡u¥Í©R¦b©I§l¶¡¡C¡v¤HµLªkºÞ¦í¦Û¤vªº¥Í©R¡A§óµLªk¾×¦í¦º´Á¡AÅý¦Û¤v¥Ã¦í¤H¶¡¡C¬JµM¥Í©R¥h¨Ó³o»òµL±`¡A§Ú­Ì§óÀ³¸Ó¦n¦n¦a·R±¤¥¦¡B§Q¥Î¥¦¡B¥R¹ê¥¦¡AÅý³oµL±`¡BÄ_¶Qªº¥Í©R¡A´²µo¥¦¯uµ½¬üªº¥ú½÷¡A¬M·Ó¥X¥Í©R¯u¥¿ªº»ù­È¡C
ªð¦^¦Cªí ¤W¤@¥DÃD