½Ð°Ý¦U¦ì°ª¤â¤j¤j
Ãö©óªþ¥ó·í¤¤·í§Ú§ïÅÜC1ªº¤U©Ô¦¡¿ï³æ¤º®e®É
¨ä¥L©Ò¦³Àx¦s®æªº¸ê®Æ¤]³£¸òµÛÅܧó
µM«á¥h¬Ý¸Ì±¦³¥Î¨ìOFFSET
¦ý¹ï©ó¸Ì±B3Àx¦s®æ=OFFSET(Y!$A$11,MATCH($C$2,Y!$C$11:$C48345,0),1)¯uªº¤£¤Ó¤F¸Ñ¥Lªº·N«ä¥i§_½Ð¤j¤j«ü¾É¤@¤U
¥H¤ÎC3Àx¦s®æ¸Ì¬°=VLOOKUP(B2,code!A2:B$935,2,FALSE)¦³¥Î¨ìVLOOKUP
¦ý¬O¸Ì±ªºcode!A2:B$935³o³¡¤À¨ì©³¥Lªº½d³ò¨ì©³ÂæbþÃä©O
Àµ½Ð¤j¤j«ü¾É¤@¤U
·P®¦
Sample.rar (124.28 KB)
|