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

vlookup ¤@ª½Åã¥Ü#NA

vlookup ¤@ª½Åã¥Ü#NA

½Ð°Ý­n±Nsheet2¦³¬Û¦Pªº²£«~¦WºÙªº¦~¥÷¨Ï¥Îvlookup©ñ¸msheet1¤¤¡A¦ýµ²ªG¤@ª½Åã¥Ü#NA¡A½Ð°Ý»yªkªº¿ù»~¦a¤è¦b­þ¸Ì©O? ÁÂÁÂ

=IF(ISERROR(VLOOKUP(B3,Sheet2!A:B,1,0)),0,VLOOKUP(B3,Sheet2!A:B,1,0))
=VLOOKUP(B3,Sheet2!A:B,1,0)


Book1.rar (8.11 KB)

¦^´_ 1# Mindyj

¦]¬°§AÆ[©À¿ù¤F¡Avlookup¬O¥Î§Aªº¥Ø¼Ð®æ¡A¥h¤ñ¹ï«ü©w½d³ò®æªº²Ä¤@Äæ¡A¤ñ¹ï¨ì¤§«á¡A«ü©w§A­nÅã¥Üªº²Ä´XÄæ¸ê®Æ¡C
¦]¦¹§A¦pªG­n¥Î°Ó«~·í¥Ø¼Ð¡A´N­n§âªí2ªº«~¦W©ñAÄæ¡A¦~¥÷©ñBÄæ¡A
µM«áI2¤½¦¡§ï³o¼Ë¦A©¹¤U©Ô¡AÀ³¸Ó´N¦æ¤F¡G
=IF(ISERROR(VLOOKUP(B2,Sheet2!A:B,2,FALSE)),"",VLOOKUP(B2,Sheet2!A:B,2,FALSE))

TOP

ÁÂÁÂmeiªº±Ð¾Ç«ü±Ð!!

TOP

        ÀR«ä¦Û¦b : ¤@­Ó¯Ê¤fªºªM¤l¡A¦pªG´«¤@­Ó¨¤«×¬Ý¥¦¡A¥¦¤´µM¬O¶êªº¡C
ªð¦^¦Cªí ¤W¤@¥DÃD