ªð¦^¦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 : ¤â¤ß¦V¤U¬O§U¤H¡A¤â¤ß¦V¤W¬O¨D¤H¡F§U¤H§Ö¼Ö¡A¨D¤Hµh­W¡C
ªð¦^¦Cªí ¤W¤@¥DÃD