Search one column, Retieve multiple rows of data

Good morning all,

I have a wiring diagram that I am breaking down into a spreadsheet for locating manufacturer part numbers for individual component. My spreadsheet is laid out with wiring harness number on the left. Second column is connector number third column pin number etc. I would like to be able to search a harness number and return al rows associated with that harness. I would like to extend that further by being able to search a connector number and return all rows associated with that number. all of the harnesses have different number of components and connectors can vary from 4 rows to 12 rows. I feel like grouping may help me here but, I have never used grouping and all of the videos that I have found are simply how to group not how to search for a group. I have included a sample of my spreadsheet. Thank You for any help and the opportunity to learn something new

Sample Pic.PNG

Greg
A10ECGent