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