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

jj369963

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

¤U¸ü¦¸¼Æ: 12

2012-8-6 14:24

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


½Ð°Ñ¾\ªþÀÉ

Hsieh

¦^´_ 7# jj369963

¤U¸ü (110.78 KB)

2012-8-22 19:36

jj369963

¦^´_ 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)

¤U¸ü¦¸¼Æ: 2

2012-8-22 16:47

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

gong

=OFFSET($A$2,MATCH($A16,$A$3:$A$12,),MATCH(B$15,$B$2:$G$2,))

jj369963

¦^´_ 4# ANGELA


    Dear Angel¤j¤j:

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

ANGELA

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")

jj369963

¦^´_ 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¦¸ÁÂÁ¦^À³

ANGELA

=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)