Search Box(Filter) Google sheet

Question

I want to create search box as bellow image.

Answer 1

With data in Data!A2:F and the search keys A1:F1 in the search box sheet, try this:

=iferror( 
  filter( 
    Data!A2:F, 
    not( 
      mmult( 
        sign(not(iferror(search(A1:F1, Data!A2:F), A1:F1 = ""))), 
        transpose(sign(column(A1:F1))) 
      ) 
    ) 
  ), 
  "(no matching data)" 
)