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

[µo°Ý] EXCEL¦³ÃöÃþ¦üVLOOKUP¨ç¼Æ¨Ï¥Îªº°ÝÃD

[µo°Ý] EXCEL¦³ÃöÃþ¦üVLOOKUP¨ç¼Æ¨Ï¥Îªº°ÝÃD



¦p¤W¡A§Ú¥i¥H¥Î=VLOOKUP("¶À",A1:F8,4,FALSE)±o¨ì9
¦ý¬O¦³¨S¦³¿ìªk¥ý§ä¨ì"¶À"¡A¦A§ä¨ì"¤ô"«á±o¥X9©O?
¤]´N¬O»¡¦³¨S¦³¨ç¼Æ¬O¥i¥H³o¼Ë¥Îªº=VLOOKUP("¶À",A1:F8,"¤ô",FALSE)

¥»©«³Ì«á¥Ñ register313 ©ó 2012-6-7 16:24 ½s¿è

¦^´_ 1# BV033DFG

=OFFSET(A1,MATCH("¶À",A2:A8,0),MATCH("¤ô",B1:F1,0))
=VLOOKUP("¶À",A1:F8,MATCH("¤ô",A1:F1,0),0)

TOP

¦^´_ 1# BV033DFG
¤]¥i¥H°Ñ¦Ò¥ÎINDEX
=INDEX(A1:F8,4,4,1)
¦ý¬O¥ý§ä¨ì"¤ô",¦A§ä¨ì"¶À"
±À¤@¤U¼Ó¤W¤j¤j, ¨ç¼Æ¦n¼F®`!!

TOP

¥Î¥æ¶°¤]¥i AAAA.gif
1

µû¤À¤H¼Æ

    • Hsieh: µ¹§A©ç©ç¤âª÷¿ú + 2

TOP

¦^´_ 2# register313
·PÁ¡AÀ°¤F§Ú«Ü¤jªº¦£

TOP

¾Ç¨ì¤@­Ó§Þ¥©
¯u¬O¤Ó·PÁ¤F
§Ú­nÄ~Äò¥[ªo¡I
FreeMan

TOP

        ÀR«ä¦Û¦b : ¦n¨Æ­n´£±o°_¡A¬O«D­n©ñ±o¤U¡A¦¨´N§O¤H§Y¬O¦¨´N¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD