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

¦bexcelªºA¤ÎB¨â¤u§@ªí¤¤ :¤ñ¹ï¥X¬Û¦P¸ê®Æ«á..

¦bexcelªºA¤ÎB¨â¤u§@ªí¤¤ :¤ñ¹ï¥X¬Û¦P¸ê®Æ«á..

¦bexcelªºA¤u§@ªí(A2)¤ÎB¤u§@ªí(B2~B50)¤¤ :¤ñ¹ï¥X¬Û¦P¸ê®Æ«á(¦pA1=B20)..
±NA¤u§@ªí A2Àx¦s®æ  =  B¤u§@ªíªºC20°£¦s®æªº¸ê®Æ

½Ð°Ý³o°ÝÃD : ¦³¤@­Ó¨ç¼Æ¥i¥H¼g¦¨¶Ü~©Î¸Ó¦p¦ó¼g²³æÂI~½ÐÀ°À°¦£¤@¤U~~ÁÂÁÂ~~

TOP

¦^´_ 2# u7490074

A¤u§@ªí A2=VLOOKUP(A1,B!$B:$C,2,0)

TOP

        ÀR«ä¦Û¦b : §g¤l¬°¥Ø¼Ð¡A¤p¤H¬°¥Øªº¡C
ªð¦^¦Cªí ¤W¤@¥DÃD