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

¤U©Ô¦¡¿ï³æªº¨Ï¥Î¤Î§@ªk

¤U©Ô¦¡¿ï³æªº¨Ï¥Î¤Î§@ªk

SHEET 1...¬O°e³f³æ
SHEET 2...¬O°e³f¸ê®Æ

¦p¦ó¦bSHEET 1 E1¿é¤J °e³f³æ¸¹, ¥Î¤U©Ô¦¡¿ï³æ VLOOKUP¥h¹ïÀ³ SHEET 2¬ÛÃö¸ê®Æ, Åã¥Ü¦b A17, B17, C17; A18, B18, C18; A19, B19, C19¸Ì

¥t¥~¦p¨Ï¥Î©w¸q¦WºÙ¤è¦¡, ¤U©Ô¦¡¿ï³æ¯à§_¸óÀÉ®×¥h¨Ï¥Î?

Book1.rar (1.76 KB)

        ÀR«ä¦Û¦b : ¤H¥Í¨S¦³©Ò¦³Åv¡A¥u¦³¥Í©Rªº¨Ï¥ÎÅv¡C
ªð¦^¦Cªí ¤W¤@¥DÃD