ªð¦^¦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»X½ªªº¦Û¥Ñ¡j¤H±`¦b¤°»ò³£¥i¥H¦Û¥Ñ¦Û¦bªº®É­Ô¡A«o³Q³oºØÀH¤ß©Ò±ýªº¦Û¥Ñ»X½ª¡AµêÂY®É¥ú¦Ó²@µLıª¾¡C
ªð¦^¦Cªí ¤W¤@¥DÃD