Precise file Link below :-

https://www.mediafire.com/file/uxfl5ldugf0ls52/search+bar.xlsx/file

Formulas :-

=filter(table name, table[field name]=k2,”No Match”)

• Table name = Total Table Data
• Field name = Names Range
• K2 = Search box Cell Code

=filter(table name, isnumber(search(k2,table[field name])),”No Match”)

=filter(table name, isnumber(search(k2,table[field name1])) + isnumber(search(k2,table[field name2])) + isnumber(search(k2,table[field name3])) + isnumber(search(k2,table[field name4])),”No Match”)

• Field name1 = Name
• Field name2 = Place
• Field name3 = Product
• Field name4 = Price