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

½Ð°Ý¦p¦ó§P©wµ¥¯Å

½Ð°Ý¦p¦ó§P©wµ¥¯Å

©êºp..µ¥¯Å¤£°÷©Ò¥HªþÀɮשε{¦¡
¥u¯à¥Î°²³]°ÝÃD:
N>Ãzµo>¦hµo>ª`·N>¥¿±`
A1   N
A2 ¦hµo
A3  N

A3­n¥Î³]µ{¦¡ÅýA1©MA2¥h¤ñ¸û§ì³Ì¤j

ÁÂÁ¦^µª

¦^´_ 1# xlarge16803

A3, °}¦C¤½¦¡ :

{=INDEX({"N";"Ãzµo";"¦hµo";"ª`·N";"¥¿±`"},MIN(MATCH(A1:A2,{"N";"Ãzµo";"¦hµo";"ª`·N";"¥¿±`"},0)))}

TOP

¦^´_ 2# JBY


¤@¯ë¤½¦¡
=LOOKUP(1,0/MATCH({"¥¿±`","ª`·N","¦hµo","Ãzµo","N"}, A1:A2,),{"¥¿±`","ª`·N","¦hµo","Ãzµo","N"})
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

{=MID("N Ãzµo¦hµoª`·N¥¿±`",MIN(FIND(A1:A2,"N Ãzµo¦hµoª`·N¥¿±`")),2)

TOP

        ÀR«ä¦Û¦b : ¡i®É¶¡¦¨´N¤@¤Á¡j®É¶¡¥i¥H³y´N¤H®æ¡A¥i¥H¦¨´N¨Æ·~¡A¤]¥i¥HÀx¿n¥\¼w¡C
ªð¦^¦Cªí ¤W¤@¥DÃD