Search & Match

[Falinaicare]

Dear Expert,

Good day.

I have a table with a large number of rows, which can make it difficult to navigate and interpret the data.

Is there a way for a user to enter values into specific cells so that the table automatically filters and displays only the records that match all the entered attributes?

If the entered attributes do not match any records, the system should display a “No record found” message.

Hope to hear from you.

Thanks.

 

[Marc L]

Hi, why not just using an Excel feature like a filter or an advanced filter ?​

​

 

[vletm]

... or slicers

 

[Gateway2026]

Hi,
Put in K5 this formula, After clearing the cells of values.

=FILTER(A5:G1000,
  (A5:A1000<>"")*
  ((A2="")+(A5:A1000=A2))*
  ((B2="")+(B5:B1000=B2))*
  ((C2="")+(C5:C1000=C2))*
  ((D2="")+(D5:D1000=D2))*
  ((E2="")+(E5:E1000=E2))*
  ((F2="")+(F5:F1000=F2))*
  ((G2="")+(G5:G1000=G2)),
  "No records found")