ªð¦^¦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 : ¡i®É¶¡µLªk¾B¾×¡j©È®É¶¡®ø³u¡Aªá¤F³\¦h¤ß¦å¡A·QºÉ¦U¦¡¤èªk­n¾B¾×®É¶¡¡Aµ²ªG¬O¡G®ö¶O¤F§ó¦h®É¶¡¡A¥B¤@µL©Ò¦¨¡I
ªð¦^¦Cªí ¤W¤@¥DÃD