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

[µo°Ý] §Ú¦p¦ó¨âºØ¬d¸ß

[µo°Ý] §Ú¦p¦ó¨âºØ¬d¸ß

¤£ª¾¹D¬Ý³o­Ó¹Ï¯à©ú¥Õ§Úªº·N«ä¶Ü?
§ÚExcelÅ޿褣¦n¸Õ¹L¤F¦b«e­±¥[if©ÎHLOOKUP³£¤£¦æ
ÁÙ¬O½Ð±Ð°ª¤â¤F
sky

¥»©«³Ì«á¥Ñ register313 ©ó 2012-4-21 22:02 ½s¿è

¦^´_ 1# qwer7632

¬¡°Ê¼s§i:À°§U¦Û¤v!¤]µ¹µªÃDªÌ¤@­Ó¤è«K!
1.µo°ÝªÌ½Ð¤W¶ÇEXCELÀ£ÁYÀÉ(¤p¾Ç¥Í¤]¥i¥H)
2.°t¦XEXCELÀɽЧâ¥\¯à»¡©ú²M·¡


F7=VLOOKUP(E7,OFFSET(D10:E14,0,MATCH(D7,D9:I9,0)-1),2,0)
©Î
F7=INDEX(D10:I14,MATCH(E7,OFFSET(D10:D14,0,MATCH(D7,D9:I9,0)-1),0),MATCH(D7,D9:I9,0)+1)

TOP

¦^´_ 2# register313


    ÁÂÁÂ¥i¥H¥Î¤F
¤£¹L§Ú¸Õ¤FOFFSET³o­Ó¨ç¼Æ(¤£¬OÁA¸Ñ¡A¤£¬O·|¥Î)
¬O­n·f°tµÛ¤~¯à¥Î§a¡A§Ú¦b¸Õ¸Õ
·PÁ§Aªºµª®×
sky

TOP

offset¨ç¼Æ±`¬Ý¨ì°ª¤â¨Ï¥Î,¬Ý¨Ó¦Û¤v¤]±o¦h§V¤O¾Ç²ß^^

TOP

        ÀR«ä¦Û¦b : ¥@¤W¦³¨â¥ó¨Æ¤£¯àµ¥¡G¤@¡B§µ¶¶ ¤G¡B¦æµ½¡C
ªð¦^¦Cªí ¤W¤@¥DÃD