Help with creating a Search table

[LBMGB0]

I am trying to create a search function in excel where you input a value which the spreadsheet then populates another table pulling from a master list of information elsewhere in the excel document.

Currently I have tried using lookup, vlookup, index, and match. All of them either don't pull the right information or give me various errors.

 

[AhoyNC]

Take a look at the FILTER function. Maybe this link will help.