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

¨Ì¶µ¥Ø¼Æ¶qÅã¥Ü

¦^´_ 1# shan0948

½Ð´ú¸Õ¬Ý¬Ý¡AÁÂÁÂ
C4=IFERROR(IF(VLOOKUP(B4,ªí¤G!A:B,2,0)=0,"",VLOOKUP(B4,ªí¤G!A:B,2,0)),"")

TOP

        ÀR«ä¦Û¦b : ¯à¥I¥X·R¤ß´N¬OºÖ¡A¯à®ø°£·Ð´o´N¬O¼z¡C
ªð¦^¦Cªí ¤W¤@¥DÃD