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

[µo°Ý] ½Ð°Ý·j´MÁa¶b±ø¥ó(¥]§t¤W¤U­­)¡A¥H¤Î¾î¶b±ø¥óªº²Å¦X¸ê®Æ?

[µo°Ý] ½Ð°Ý·j´MÁa¶b±ø¥ó(¥]§t¤W¤U­­)¡A¥H¤Î¾î¶b±ø¥óªº²Å¦X¸ê®Æ?

¦pÃD Book2.rar (2.68 KB)

J2=VLOOKUP(H3,A:F,MATCH(I3,$1:$1,0))
¦V¤U½Æ»s
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

=INDEX($C$2:$F$63,MATCH(H2,$A$2:$A$63),I2+1)

TOP

·PÁ¤G¦ì¤j¤j¡AÁÂÁ±z~

TOP

        ÀR«ä¦Û¦b : °µ¸Ó°µªº¨Æ¬O´¼¼z¡A°µ¤£¸Ó°µªº¨Æ¬O·Mè¡C
ªð¦^¦Cªí ¤W¤@¥DÃD