Lookup - values between 2 columns and bring back 3rd column data for all instances

Summary
I have a file that has a large number of rows (about 26,000) that contains several columns of data (39).

I have a list of approximately 300 items that I need to compare against the file and bring back every instance of the 300, where there is a match and bring back specific information contained in another column.

Detail
I have a list of expired part numbers (all unique) and I need to know where each expired part number exists, by bring back a 3rd column of information - the location tag( Which is a unique identifier) - NOTE - the items in the expired list can exist in multiple locations and a location can have multiple expired SKU's

I am able to re-arrange my data to put the columns I need in any order from A-Z so for purposes of helping with a formula - I can move the data columns I need to A,B,C

Can someone assist with the formula I could use to bring back all values that match with the specific location tag data?

Thank you

Thank you - both items were helpful