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

vlookup ¾ú¥vªÑ»ù°ÝÃD

vlookup ¾ú¥vªÑ»ù°ÝÃD

·Q¥Îvlookup §ä´M­ÓªÑ¾ú¥vªÑ»ù,¨Ã°lÂÜ
¦]¦³¥æ¤e¤ñ¹ï°ÝÃD,©Ò¥H½Ð¸Ñ´b,ÁÂÁ °lÂÜ.rar (182.31 KB)

¦^´_ 1# yan2463

D3=VLOOKUP(B3,¶}½L»ù!A:BK,MATCH(--TEXT(¤W¥«¸ê¨é!E1,"yyyymmdd"),¶}½L»ù!2:2,0),)
E3=VLOOKUP(B3,¦¬½L»ù!A:BK,MATCH(--TEXT(¤W¥«¸ê¨é!E1,"yyyymmdd"),¦¬½L»ù!2:2,0),)

TOP

¦^´_ 2# samwang

ÁÂÁ§A,¥i¥H¨Ï¥Î¤F

TOP

        ÀR«ä¦Û¦b : ¡i°±º¢¤£«e¡A²×µL©Ò±o¡j¤H³£°g©ó´M§ä©_ÂÝ¡A¦]¦Ó°±º¢¤£«e¡FÁa¨Ï®É¶¡¦A¦h¡B¸ô¦Aªø¡A¤]¤FµL¥Î³B¡A²×µL©Ò±o¡C
ªð¦^¦Cªí ¤W¤@¥DÃD