Search by criteria A or criteria B

[stanco]

Hi, I found this tutorial online that allows me to do a partial search, While it was useful, it does not fully meets my needs.

formula used

=FILTER(Customers2,(ISNUMBER(SEARCH(G2,Customers2[First Name])))+(ISNUMBER(SEARCH(G2,Customers2[Last Name])))+(ISNUMBER(SEARCH(G2,Customers2[Favorite Cookie]))),"none")

I would like to know if it is possible to include one more search box and make it searchable by either the first name or favourite cookie type? (i.e. i will have two search boxes and users can search by either box)

also, if i were to add gender into my database table, can i include a dropdown to show only the males or females based on the search term input by user?