Can someone explain the mistake in the below formula??

=IF(IFERROR(SEARCH({"Request for Admin","Request for Info"},A2),"FALSE"),"Yes","No")

I need correction only with above format.... If any new format also, I should recheck....

CodePudding user response：

Not sure what is your actual goal. If you want result Yes when one of your search item match to A2 cell then could try-

=IF(OR(ISNUMBER(SEARCH({"Request for Admin","Request for Info"},A2))),"Yes","No")