jackifizzle,
Welcome to the forum!
Attached is a modified version of your exammple workbook. In sheet 'Search' cell A10 is the following array formula so it needs to be entered with Ctrl+Shift+Enter:
And then its copied over to column G and down for 30 rows. While this solution works, it isn't exactly efficient... at all. If you have experience with VBA (macros and userforms) I would instead recommend making a userform to pull the desired data. What you're looking for could also be accomplished via Access queries, which is probably the best method to obtain the desired results.
Bookmarks