[Excel 2007] Trying to pull every instance of names on a smaller list from larger spreadsheet.

I need to make reports on the dispensing of certain medications. The medication lists I have are about 25-100 entries long and the dispensing data is in spreadsheets with 300+ lines.

Filtering by hand would be too cumbersome, especially as most meds get dispensed in numerous forms and strengths (ie Extra Strength Tylenol Gel Caps, Children's Tylenol Oral Suspension, Tylenol with Codeine 300mg/60mg, etc. etc.) and I need to pull the EXACT med strength and form as listed.

All the potential solutions I've found use functions like AGGREGATE and FILTER that aren't available in Excel 2007.

Example meds list: https://imgur.com/OrWG7S5

Example dispensing data: https://imgur.com/Y4J5G0w