Hi. I have an issue with a formula that doesn’t seem to be working. It was working until I added the AND statement to include the F = Y part. I need it to look in two separate columns, one with a simple yes or no and one with a search within text, then give me the joined list of correct results.
Any ideas, hopefully I am just being a bit stupid and missing the obvious.
=TEXTJOIN(“;”,TRUE,IF(AND(Consultees!F2:F46=“Y”,ISNUMBER(SEARCH(A2,Consultees!E2:E46))),Consultees!C2:C46,””))
Any ideas, hopefully I am just being a bit stupid and missing the obvious.
=TEXTJOIN(“;”,TRUE,IF(AND(Consultees!F2:F46=“Y”,ISNUMBER(SEARCH(A2,Consultees!E2:E46))),Consultees!C2:C46,””))