202208071042查找 對應名稱與位置 (10328)

F5=IFERROR("B"&MATCH(E5,B:B,),"C"&MATCH(E5,C:C,))

G5=IFERROR(VLOOKUP(E5,B:C,2,),VLOOKUP(E5,IF({1,0},C:C,B:B),2,))

另解 F5=ADDRESS(SUMPRODUCT(N(B$2:C$9=E5)*ROW($2:$9)),SUM(MMULT(N(B$2:C$9=E5),{2;3})),4)

另解 G5=INDIRECT(ADDRESS(SUMPRODUCT(N(B$2:C$9=E5)*ROW($2:$9)),5-SUM(MMULT(N(B$2:C$9=E5),{2;3})),4))

沒有上一則|日誌首頁|沒有下一則
回應
關鍵字
    沒有新回應!
    blank