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
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?
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?