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

[¤À¨É] ¤@­Ó¤p°ÝÃD

[¤À¨É] ¤@­Ó¤p°ÝÃD

Dear ¤p°ÝÃD.rar (7.41 KB)

DEAR¤j¤j­Ì:

·Q±Nªí®æ1ªº¼Æ¦r¶ñ¤Jªí®æ2¡A½Ð°Ý¦³¤°»ò¤èªk¡H

¥Ø«e·Q¨ìindex¡A¦ý¤£ª¾«ç»ò¼g¤½¦¡¡H

§Æ±æ¥i¥H¦³§ó¦h¤£¤@¼Ëªº°Q½×»P¤èªk¡AÁÂÁ¡C


½Ð°Ñ¾\ªþÀÉ

¥»©«³Ì«á¥Ñ ANGELA ©ó 2012-8-6 15:25 ½s¿è

=VLOOKUP($A16,$A$3:$G$12,MATCH(B$15,$A$2:$G$2,),)
OR
=INDEX($B$3:$G$12,MATCH($A16,$A$3:$A$12,),MATCH(B$15,$B$2:$G$2,))
OR
=INDIRECT("R"&MATCH($A16,$A$1:$A$12,)&"C"&MATCH(B$15,$A$2:$G$2,),0)

TOP

¦^´_ 2# ANGELA


    Dear Angel ¤j¤j¡G

·PÁ±zªº¦^ÂСA¦ý¬Ý¤£¤ÓÀ´=INDIRECT("R"&MATCH($A16,$A$1:$A$12,)&"C"&MATCH(B$15,$A$2:$G$2,),0)
³o³¡¤À Ref_text  R3C5¤£¬O«Ü¤F¸Ñ¡A¥¿¦b²z¸Ñ¤¤¡A¦pªG¤£¶û³Â·Ð¥i¥Hµy·LÁ¿¸Ñ¶Ü¡H·P¿E


¦A¦¸ÁÂÁ¦^À³

TOP

INDIRECT¦³¨âºØ°Ñ·Ó¤è¦¡,R1C1°Ñ¼Æ¬°0¡A¤ÎA1°Ñ¼Æ¬°1¡A,©Î¬Ù²¤¡C
B16=INDIRECT("R"&MATCH($A16,$A$1:$A$12,)&"C"&MATCH(B$15,$A$2:$G$2,),0)
            MATCH($A16,$A$1:$A$12,)=3  MATCH(B$15,$A$2:$G$2,)=5
       =INDIRECT("R3C5",0)
       =°Ñ·Ó²Ä3¦C²Ä5Äæ
       =INDIRECT("E3")

TOP

¦^´_ 4# ANGELA


    Dear Angel¤j¤j:

             ÁÂÁ±zªº¦^ÂСA¸ÑÄÀªº«Ü¸Ô²Ó¡A·P¿E¡C

TOP

=OFFSET($A$2,MATCH($A16,$A$3:$A$12,),MATCH(B$15,$B$2:$G$2,))
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

¦^´_ 6# gong


    ¦^´_gong¤j¤j¡G

    ÁÂÁ±zªº¦^À³¡A¤£¹L¤£¤~ªº§ÚÁÙ¦³¤@­Ó¤pºÃ°Ý(¦pªþÀÉ)¡G


          ¦pªGª½±µ±N¤½¦¡¶K¤W

           OFFSET($A$2,MATCH($A16,$A$3:$A$12,),MATCH(B$15,$B$2:$G$2,))
          ¦ý¬Oª½±µ¥k©ì¤U²¾¡A¦ü¥G·|Åܦ¨³£¬O20

               »Ý­n¨C¦¸³£«öF2+enter¡A¤~·|¥¿½T¿é¤J¡C
             «Ü¦n©_¬°¤°»ò©O¡H¬O¦]¬°offset³o­Ó¨ç¦¡ªºÃö«Y¶Ü¡H
¤p°ÝÃD_0822.rar (9.93 KB)


PS¡G¥H¤Uµ¹¦U¦ì½×¾Âªº¦U¦ì«e½ú»P¥ý¶i­Ì
http://forum.twbts.com/thread-6795-1-1.html
http://forum.twbts.com/thread-7464-1-1.html
¥H¤W³sµ²©|¥¼±o¨ì¦^À³¡A«ô½Ð¦U¬°¤j¤j­Ìªº«ü±Ð¡AÁÂÁ¡C

TOP

¦^´_ 7# jj369963

¥¼©R¦W.png
2012-8-22 19:36
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

        ÀR«ä¦Û¦b : ¡i®É¤é²öªÅ¹L¡j¤@­Ó¤H¦b¥@¶¡°µ¤F¦h¤Ö¨Æ¡A´Nµ¥©ó¹Ø©R¦³¦hªø¡C¦]¦¹¥²¶·»P®É¶¡Ävª§¡A¤Á²ö¨Ï®É¤éªÅ¹L¡C
ªð¦^¦Cªí ¤W¤@¥DÃD