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

[µo°Ý] ¤½¦¡¦ì§}ªº°ÝÃD

[µo°Ý] ¤½¦¡¦ì§}ªº°ÝÃD

¥¼©R¦W.png
2019-9-4 17:35

EX¡JAR9="$B"&AP3&":$I"&AP3  => ·|Åã¥Ü $B9:$I9
¦ý®M¶iAR3ªº¤½¦¡
=INDEX($B$2:$I$2,MATCH(AQ3,"$B"&AP3&":$I"&AP3,0))
¿ï¨ú"$B"&AP3&":$I"&AP3«öF9  =>Åã¥Ü  "$B9:$I9"

·Q­nÅýAR3¤½¦¡¤¤ªº"$B"&AP3&":$I"&AP3Åã¥Ü¥¿½Tªº¦ì§}$B9:$I9
¥H§Q¤½¦¡¯à¶¶§Q°õ¦æ¡C
½Ð°Ý¡JAR3ªº¤½¦¡À³¸Ó¦p¦ó­×¥¿?
ÁÂÁÂ!
¤½¦¡¦ì§}ªº°ÝÃD.rar (6.41 KB)

¦^´_ 1# ziv976688

¤U¦C¨â¦¡³£¥i¥H

=INDEX(B$2:I$2,MATCH(AQ3,OFFSET(B$1:I$1,AP3-1,)))
=INDEX(B$2:I$2,MATCH(AQ3,INDEX(B:I,AP3,),))
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 2# ML089
Mª©¥D:±z¤Ó¯«¤Fb^_^d
¤£¤~ªº«äºû¤Ó¯U¯¶©M¦ºªO¤F^^"
ÁÂÁ±zªº½ç±Ð~·P®¦........!

TOP

¦^´_ 3# ziv976688

­ì¦¡
=INDEX($B$2:$I$2,MATCH(AQ3,"$B"&AP3&":$I"&AP3,0))

¨ä¤¤ "$B"&AP3&":$I"&AP3 ºâ¬O¤å¦r¨Ã¤£¬OÀx¦s®æ°Ï°ì

¥i¥H¨Ï¥Î INDIRECT §ï¬°
=INDEX(B$2:I$2,MATCH(AQ3,INDIRECT("B"&AP3&":I"&AP3),0))
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 4# ML089
Mª©¥D:
¥»¨Ó¤£¤~¤]¬O¦³¦P¼Ë¥ÎINDIRECT¡A¦ý¤£ª¾¬O­þ¸Ì¦³¿ù¸m¡A¤@ª½¶]¤£¥X¥¿½Tµª®×^^"
ÁÂÁ±z¼ö¤ßªº¦A¦¸½ç±Ð~·P®¦^^

TOP

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