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

[µo°Ý] Ãö©óVLOOKUPªº¨Ï¥Î~(¥H¸Ñ¨M)

[µo°Ý] Ãö©óVLOOKUPªº¨Ï¥Î~(¥H¸Ñ¨M)

¥»©«³Ì«á¥Ñ BV033DFG ©ó 2011-11-20 19:45 ½s¿è

=VLOOKUP("²Ä5±ø",A1:B5,2,FALSE)
½Ð°Ý¬°¤°»ò¤W­±³o­Ó¥i¥H¦¨¥\¦^¶Ç"²Ä5±ø"«á­±¤@®æªº¼Æ­È

µM¦Ó¹³¤U­±³o­Ó¡A§Ú¦b¥ÒÀɮ׸̭n§ì¤AÀÉ®×ùØ­±ªº¼Æ­È«oµLªk¶Ç¦^
=VLOOKUP([¤AÀÉ®×.xlsx]¤u§@ªí1!"²Ä5±ø",[¬¡­¶Ã¯1.xlsx]¤u§@ªí1!$A$1:$B$5,2,FALSE)

=VLOOKUP("²Ä5±ø",[¬¡­¶Ã¯1.xlsx]¤u§@ªí1!$A$1:$B$5,2,FALSE)

TOP

        ÀR«ä¦Û¦b : ¤Hªº²´·úªø¦b«e­±¡A¥u¬Ý¨ì§O¤Hªº¯ÊÂI¡Aµ·²@¬Ý¤£¨ì¦Û¤vªº¯ÊÂI¡C
ªð¦^¦Cªí ¤W¤@¥DÃD