google-sheetssearch-box

Search Box(Filter) Google sheet


enter image description here

I want to create search box as bellow image.


Solution

  • 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)" 
    )