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

[µo°Ý] Vlookup¨D§U

¥»©«³Ì«á¥Ñ p212 ©ó 2015-3-10 08:58 ½s¿è

¦^´_ 2# JBY
­Y©ó¡u¬Û¦P¤é´Á¡v¦³¡u¦h¤H¡v±¡ªp¤U¡A«h2#¤§¤½¦¡¤£²Å´Á«Ý¡C
½Ð°Ý¦p¦ó­×§ï¡H
ÁÂÁ¡I

TOP

¥»©«³Ì«á¥Ñ p212 ©ó 2015-3-10 16:06 ½s¿è

¦^´_ 4# JBY
没·Q¨ì¬õ¦r³¡¥÷¥i¦p¦¹¹B¥Î¡A»s³yMATCHªºlookup_array¡C
=INDEX($C:$C,MATCH(SMALL(IF($A:$A=$G2,$B:$B),COLUMN(A:A)),IF($A:$A=$G2,$B:$B),))
·PÁ¸Ѵb¡I
µù¡GÁô½ª¤½¦¡§ä¤£¨ìªºµ²ªG#NUM!¡A±N¤§Åã¥Ü¬°¡uªÅ¥Õ¡v¡A°}¦C¤½¦¡¡G
=IFERROR(INDEX($C:$C,MATCH(SMALL(IF($A:$A=$G2,$B:$B),COLUMN(A:A)),IF($A:$A=$G2,$B:$B),)),"")
½Ð°Ñ¦Ò¡I

TOP

        ÀR«ä¦Û¦b : ¦Û¤v®`¦Û¤v¡A²ö¹L©ó¶ÃµoµÊ®ð¡C
ªð¦^¦Cªí ¤W¤@¥DÃD