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
then You could see all the time - what You could search & match?

 

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

 

[rick k]

 

[Falinaicare]

Dear all experts,

Thanks for all your helpful Excel recommendations. I will ask questions if anything is unclear.

 

[Gateway2026]

you are welcome

 

[John Jairo V]

Hi everyone!

One option could be:

=FILTER(A5:G99,BYROW((A5:G99=A2:G2)+(A2:G2=""),AND),"Record not found")

Blessings!

 

[Lithal_Casper]

This is definitely doable without too much headache. Since you're on a newer version of Excel, the FILTER function combined with ISNUMBER(SEARCH()) is usually the cleanest way to handle multiple attributes at once. You can wrap the whole thing in an IFERROR or use the built-in [if_empty] argument in the FILTER function to display your 'No record found' message. It makes the sheet feel much more like a dynamic dashboard!