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

·Q±Nsheet1¸ê®Æ¿z¿ï«á¤À§O¦Û°Ê©ñ¨ìsheet2..sheet4

¦^´_ 1# wahhk

B2=IF(A2="","",HLOOKUP($B$1,Sheet1!$B:$D,ROW(),0))

Book1.rar (2.54 KB)

TOP

        ÀR«ä¦Û¦b : ¹ï¤÷¥À­nª¾®¦¡A·P®¦¡B³ø®¦¡C
ªð¦^¦Cªí ¤W¤@¥DÃD