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

VLOOKUP°ÝÃD

VLOOKUP°ÝÃD

½Ð¦U¦ì«ü¾É
VLOOKUP(DZ7,C:F,4,FALSE)  dzÁÖcÄݬۦP¸ê®Æ
  §Y§ä¥XDZ7¦bFªº¸ê®Æ
­Y»Ý­n½Õ¥X  DZ7¦bBªº¸ê®ÆÀ³¦p¦ó¼g?
VLOOKUP(DZ7,B:C,?,fALSE) ???? ©Î¬O ????
¦hÁÂ

¦^´_ 1# jim
½Ð¸Õ¸Õ
=INDEX(B:C,MATCH(DZ7,C:C,0),1)

TOP

¥»©«³Ì«á¥Ñ p212 ©ó 2015-1-7 08:46 ½s¿è

¦^´_ 1# jim
¸ê®Æ¤º®e¡uDZ7¡v¦ì©óCÄæ¬Y¤@Àx¦s®æ¡A¤µ­n½Õ¥X¡uDZ7¡v©óBÄ檺¹ïÀ³¸ê®Æ¡A«h©ó¥ô¤@Àx¦s®æ³]©w¤½¦¡
=INDEX(B:B,MATCH("DZ7",C:C,0))
½Ð°Ñ¦Ò¡I

TOP

¦hÁ­Ǧ칩¤OÀ°¦£¦A¦¸·PÁÂ

TOP

¥ç¥i§âBÄæ¸ê®Æ°Å¤U´¡¤JCÄæ«á
?=2

TOP

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