Showing posts with label Filter. Show all posts
Showing posts with label Filter. Show all posts

Tuesday, November 17, 2026

How to display dynamically all records matching the selected value

 Assuming:

  • Data range: A3:J1061

  • Dropdown selection: D2

  • Criteria column: J4:J1061

  • Headers are in row 3.

Enter this formula in the cell where you want the filtered results to appear (e.g. A1064):

How it works

  1. Select a value from the dropdown in D2.

  2. Excel checks every corresponding value in J4:J1061.

  3. All matching rows from columns A to J are displayed automatically.

  4. Changing the dropdown updates the results instantly.


=FILTER(A4:J1061,J4:J1061=D2,"No matching records found")
or,
=IFERROR(CHOOSE({1;2},A3:J3,FILTER(A4:J1061,J4:J1061=D2)),"No matching records found")
or,
=FILTER(Sheet1!A4:J1061,Sheet1!J4:J1061=K2," ")

How to display dynamically all records matching the selected value

 Assuming: Data range: A3:J1061 Dropdown selection: D2 Criteria column: J4:J1061 Headers are in row 3. Enter this formula in the cell where ...