returning entire row based on single or multiple criteria

[cdevericks]

On sheet 1 I have nine columns with identifying criteria that pertain to one object. On sheet 2 I want to label the columns as the same as sheet 1 so a user can type in the criteria to search for underneath the labeled columns. Some instances it may only return one row but could quite possibly return multiple rows. I don't know what function or how to set it up to make it work. Any help would be appreciated. I have attached a sameple workbook set up similiar to what I need it to be.