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

VLOOKUP±q¥k¦V¥ª¬d¸ß-°®©[¤j®¿²¾

VLOOKUP±q¥k¦V¥ª¬d¸ß-°®©[¤j®¿²¾

¤@¯ë±¡ªp¤UVLOOKUP¥u¯à±q¥ª¦V¥k¬d¸ß, ­Y»Ý­n±q¥k¦V¥ª½Ð¬Ý¹Ï
ss

¤@¯ë±¡ªp¤UVLOOKUP¥u¯à±q¥ª¦V¥k¬d¸ß, ­Y»Ý­n±q¥k¦V¥ª½Ð¬Ý¹Ï
sunnyso µoªí©ó 2013-11-16 10:44

update
ss

TOP

¸U¤À·PÁ¤À¨É, ÁÂÁÂ

TOP

¤]¥i¥H¥Î INDEX + MATCH¨Ó³B²z

=INDEX(A2:A5,MATCH(A10,B2:B5,))
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 4# ML089
ss

TOP

        ÀR«ä¦Û¦b : ¬Ý§O¤H¤£¶¶²´¡A¬O¦Û¤v­×¾i¤£°÷¡C
ªð¦^¦Cªí ¤W¤@¥DÃD