Ads
=IFNA(HYPERLINK("#"&CELL("address",INDEX((INDIRECT({"123ABCD";"234BCDE";"345DEFG"}&"!A:A")),MATCH(B5,(INDIRECT({ "123ABCD";"234BCDE";"345DEFG" }&"!A:A")),0))),B5),"")
Ads
=INDEX(B:B,SMALL(IF($A$1:$A$15=$D$2,ROW($A$1:$A$15),1000),ROW(A1)))&""
Ads
或者replace = with =
又可能係啲cell format咗做text