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

No comments:

Post a Comment

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 ...