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

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

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

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

¦p¹Ï

001.JPG
2014-11-14 12:16

­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 : «Ý¤H°h¤@¨B¡A·R¤H¼e¤@¤o¡A´N·|¬¡±o«Ü§Ö¼Ö¡C
ªð¦^¦Cªí ¤W¤@¥DÃD