Assuming:
Data range:
A3:J1061Dropdown selection:
D2Criteria column:
J4:J1061Headers are in row 3.
Enter this formula in the cell where you want the filtered results to appear (e.g.
A1064):How it works
Select a value from the dropdown in
D2.Excel checks every corresponding value in
J4:J1061.All matching rows from columns A to J are displayed automatically.
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," ")