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

[µo°Ý] ¼Ð·Ç¤u®É¶}³æ¥ÎEXCEL

½Ð±Ð¤@¤U¦U¦ì¤j®v ¥Î³o¼Ë
=VLOOKUP(A2,¼Ð·Ç¤u®É!A1:B300,2,0)
©M
=IF(A2="","",VLOOKUP(A2,¼Ð·Ç¤u®É!A:B,2,)) ®t§O¦b¨º

TOP

        ÀR«ä¦Û¦b : ¦³¤ß´N¦³ºÖ¡A¦³Ä@´N¦³¤O¡A¦Û³yºÖ¥Ð¡A¦Û±oºÖ½t¡C
ªð¦^¦Cªí ¤W¤@¥DÃD