Excel Formula for Matching

marcwithak629 

=LET(
    in, [HamzaQ.xlsx]WorkingList!$B$2:$G$85948,
    key, $G3,
    inF, INDEX(in, , 2),
    inM, INDEX(in, , 3),
    inFLoc, IFERROR(SEARCH(key,inF),-1),
    inMLoc, IFERROR(SEARCH(key,inM),-1),
    keyFindsF, TRIM(SWITCH(inFLoc,-1,FALSE,1,LEFT(inF,LEN(key)+1),MID(inF,inFLoc-1,LEN(key)+2))),
    keyFindsM, TRIM(SWITCH(inMLoc,-1,FALSE,1,LEFT(inM,LEN(key)+1),MID(inM,inMLoc-1,LEN(key)+2))),
    passF, IFS(key=keyFindsF,TRUE, (key&",")=keyFindsF,TRUE,TRUE,FALSE),
    passM, IFS(key=keyFindsM,TRUE, (key&",")=keyFindsM,TRUE,TRUE,FALSE),
    fsetF, FILTER(in, passF, 0),
    fsetM, FILTER(in, passM, 0),
    outF, IFERROR(INDEX(fsetF,2,), INDEX(fsetF,1,)),
    outM, IFERROR(INDEX(fsetM,2,), INDEX(fsetM,1,)),
    out, IF(outF<>"", outF, IF(outM<>"", outM, ""))
)

Since no one has responded to this for over a day or more, I am sending the attached formula that I regenerated with the help of the AI.

I haven't been able to try this out, so please save your file in advance so as not to evaluate any errors in the original file.

Try the formula, maybe it will help you further with your plans. If not...please just ignore it.

But I still hope it helps.