前代碼 找出后四位数 (10283)

G1{=VLOOKUP(E1,TRIM(MID(SUBSTITUTE(I$5:I$11,"=",REPT(" ",9)),{1,9},9)),2,)

另解=RIGHT(VLOOKUP(E1&"=*",I:I,1,),4)

另解{=RIGHT(INDEX(I:I,MATCH(E1&"=*",I:I,)),4)

另解=-LOOKUP(,-SUBSTITUTE(I5:I11,I13&"=",))