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

[µo°Ý] Index ¨ç¼Æ°ÝÃD

[µo°Ý] Index ¨ç¼Æ°ÝÃD

§Ú¦³¤@²Õ¸ê®Æ¦b¥Î index ¨ç¼Æ¨ú¥X§Ú·Q­nªº¼Æ¾Ú®É ( Data Äæ )
¬°¤°»ò M2~M26 ªº­È¬O #VALUE! ¡H
¬O¦]¬°§Ú C1~I26 ¨S¦³¸ê®ÆªºÃö«Y¶Ü¡H

½Ð°Ý­Y§Ú·Q§â¨ú¥Xªº¼Æ¾Ú±q M2 ¶}©lÅã¥Ü
¦Ó¤£¬O±q M27 ¶}©l¦³¼Æ¾Ú
§Úªº¤½¦¡¸Ó«ç»ò§ï©O¡H

ÁÂÁ¡ã
Test.zip (13.77 KB)

=INDEX($C$27:$I$38,ROW(A1),$L$2)

TOP

ÁÂÁÂ oobird

§Ú¤F¸Ñ°ÝÃD¥X¦b­þ¸Ì¤F¡I

TOP

¥i¥H½Ð°Ý¤@¤U¶Ü
ROW(A1)ªº§@¥Î¬O¤°»ò???
$L$2ªº³¡¥÷§Úª¾¹D
·Ð½Ð«ü¥¿
ÁÂÁÂ
jeason

TOP

¦^´_ 4# brabus


    ROW(A1)=1
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

        ÀR«ä¦Û¦b : ¨ü¤HÂI¤ô¤§®¦¡A¶··í´é¬u¥H³ø¡C
ªð¦^¦Cªí ¤W¤@¥DÃD