ªð¦^¦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 : ¤@­Ó¯Ê¤fªºªM¤l¡A¦pªG´«¤@­Ó¨¤«×¬Ý¥¦¡A¥¦¤´µM¬O¶êªº¡C
ªð¦^¦Cªí ¤W¤@¥DÃD