往上取尾字非數字 (14168)

J4=INDEX(LOOKUP(ROW(3:13),ROW(3:13)/ISERR(-RIGHT(C$3:C$13)),C$3:C$13),MATCH(G4,C:C,)-2)

另解{=LOOKUP(SUM((C$3:C13=G4)*ROW($3:13)),IF(ISERR(-RIGHT(C$3:C13)),ROW($3:13)),C$3:C13)