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

[µo°Ý] µ¹¿é¤JªÌ ¿é¤J«~¦W«á ¦Û°Ê±a¥X a & b ³o¨â®æ

[µo°Ý] µ¹¿é¤JªÌ ¿é¤J«~¦W«á ¦Û°Ê±a¥X a & b ³o¨â®æ

¤â¤W¦³ªº¸ê®Æ¥u¦³³o 3 ­Ó
¦³¨S¦³¿ìªk
µ¹¿é¤JªÌ ¿é¤J«~¦W«á ¦Û°Ê±a¥X a & b ³o¨â®æ

¦]¬°¸ê®Æ´N¥u¦³³o¤T­Ó
·Q­n©w¸q¦WºÙ ¦n¹³¨S¨º»ò¦hÃöÁä¦r




­YµL¶~¨Æ±¾¤ßÀY
«K¬O¤H¶¡¦n®É¸`

¥»©«³Ì«á¥Ñ p212 ©ó 2014-7-30 08:23 ½s¿è

¦^´_ 1# cbl0924
Àx¦s®æJ6¿é¤J
=IFERROR(VLOOKUP($I6,$C:$E,MATCH(J$5,$C$3:$E$3,0),0),"")
¦V¥k¡B¦V¤U½Æ»s¤½¦¡
½Ð°Ñ¦Ò¡I

TOP

¦^´_ 1# cbl0924


    ¥ÎVLOOKUP(A,B,C) OR HLOOKUP(A,B,C)

A=C3Àx¦s®æ,µ¹¿é¤JªÌ¿é¤Jªº¸ê®Æ

B=¿ï¨ú¸ê®Æ®w½d³ò

C=·í´M§ä¨ìA­È,­n¦^¶Ç¸ê®Æ®w¤¤A­È
±o¥ªÃä²Ä´X­Ó¦ì¤l
©Î
A­È¤U¤è²Ä´Xªº¦ì¤l


=VLOOKUP(A1,Z1:ZA20,3)

·N«ä¬O»¡
¤ô¥­´M§ä Z1¨ìZ30 ¤¤A1¤§­È
·í§ä¨ì«á ¦^¶Ç¥ªÃä²Ä¤@­ÓÄ欰¤½¦¡¦p¤U=VLOOKUP(A1,Z1:ZA20,2)
·í§ä¨ì«á ¦^¶Ç¥ªÃä²Ä¤G­ÓÄ欰¤½¦¡¦p¤U=VLOOKUP(A1,Z1:ZA20,3)

§Æ±æ§AÀ´
Cyssuc

TOP

ÁÂÁ p212 »P cyssuc ªº¦^µª
p212ªº¤½¦¡ §Ú±a¤£¥X¨Ó
³Ì«á¥Î¤F cyssuc »¡ªº vlookup
§Úªº¸£¤l´N¬O¨SÂà¥X¨Ó
¤@ª½¥H¬°¤@©w­n©w¸q¦WºÙ
¤~±aªº¥X¨Ó¡K

·PÁ¨â¦ì°ª¤âªº¸Ñ±Ï ¡I
¦A¦¸·PÁ ¡I
­YµL¶~¨Æ±¾¤ßÀY
«K¬O¤H¶¡¦n®É¸`

TOP

        À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