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

[µo°Ý] ¨Ï¥ÎVLOOPUP¨ç¼Æ¤ñ¹ï¥¿½Tªº¦W¦r(¦³±ø¥ó¤ñ¹ï)

[µo°Ý] ¨Ï¥ÎVLOOPUP¨ç¼Æ¤ñ¹ï¥¿½Tªº¦W¦r(¦³±ø¥ó¤ñ¹ï)


vloopup.zip (39.66 KB)

½Ð¨ó§UÀ°¦£¡AÁÂÁÂ!

±ø¥ó:

IÄæ¦ì·í¤¤¦³µù°O¤u¸¹ªº¥HIÄæ¦ì¬°¥D¡A¨ÃÅã¥Ü¦W¦r

¦pªGIÄæ¦ìµLµù°O¤u¸¹«h¥HHÄæ¦ì¤u¸¹¬°¥D¡A¨ÃÅã¥Ü¦W¦r

2016-05-18_174553.jpg (77.62 KB)

2016-05-18_174553.jpg

¦^´_ 1# chiang0320



­n¤ñ¹ï¦¨¦p¹Ï¤ùÅã¥Ü¥¿½T¦W¦r

TOP

http://blog.xuite.net/hcm19522/twblog/414133280

TOP

¥»©«³Ì«á¥Ñ chiang0320 ©ó 2016-5-18 20:29 ½s¿è

¦^´_ 3# hcm19522


TO     hcm19522

ÁÂÁ§Aªº¦^ÂСA¦ý¬ONOTEÄæ¦ì¬O¶Ã½X  (¦³¥i¯à¬O¶Ã½X¦³¥i¯à¬OªÅ¥Õ)¡A¤u¸¹¤£·|¦b¦r¦ê·í¤¤ªº©T©w¦ì¸m©Ò¥H¤£¯à¥ÎLEFT¨ç¼Æ¤ÎRIGHT¨ç¼Æ

¬O§_¯à¦AÀ°¦£­×§ï¤@¤U¡AÁÂÁÂ!

TOP

¥»©«³Ì«á¥Ñ ML089 ©ó 2016-5-19 06:38 ½s¿è

¦^´_ 1# chiang0320


    G3 =LOOKUP("ùÜ",IF({1,0},VLOOKUP(H3,B:C,2,),LOOKUP(,-FIND(B$3:B$13,I3),C$3:C$13)))
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 5# ML089


    TO ML089

ÁÂÁ§Aªº¨ó§U

½Ð°Ý "¼_" ¬O¤°»ò·N«ä?

TOP

¦^´_ 6# chiang0320


    "ùÜ" ¦rªº¦r½X«Ü¤j¡A¦bLOOKUP¨ç¼Æ¤¤¥Î¨Ó§ä¨ì³Ì«á¤@²Õ¦r²Å¡C
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 7# ML089


  TO ML089

ÁÂÁ§A¡AÀ°§U«Ü¤j

TOP

¥»©«³Ì«á¥Ñ hcm19522 ©ó 2016-5-19 09:57 ½s¿è

=VLOOKUP(IF(I2="",H2,LOOKUP(1,0/FIND(B$2:B$12,I2),B$2:B$12)),B:C,2,)
3¼Ó¤w­×§ï

TOP

        ÀR«ä¦Û¦b : ¤@­Ó¯Ê¤fªºªM¤l¡A¦pªG´«¤@­Ó¨¤«×¬Ý¥¦¡A¥¦¤´µM¬O¶êªº¡C
ªð¦^¦Cªí ¤W¤@¥DÃD