How to return multiple values that match a single search criteria?

I'm fairly new to Excel, and I've been struggling with this problem for several hours now.

Attached is a sample workbook, but essentially what I'm looking to do is automate the process of searching through a data set where the value of interest (in this case, names) often has multiple entries, with different values attached to each instance.

I would like to be able to get a list of all values in a given column that match a specific name in another column.

Currently I'm using a basic INDEX/MATCH search just to see whether the data exists at all, but that's only half of what I have to do here, and I'm totally stumped on how to get a comprehensive list of all matches.

For reference, if you look at the sample, what I need is a list of all values in the "CPT" column that match the name searched for in the first column.

The actual data set size is at most 3-400 entries, if that makes a difference in how to approach this.

CPT Sample Book.xlsx

Thanks.

Ah, nice!

It will do, at the very least.

Ideally, the solution would be a bit more modular. There are multiple workbooks that it would be great to move this data into, if feasible.

For example, being able to have another workbook with a "Name" and "CPT" column referencing this, with only one row per name, and CPT populated in a "99284, 98010, ..." format in a single cell for each name would be the best case scenario here.

Thanks though, this is definitely useful regardless of whether the above is doable