Lookup - Bring Up List Of Multiple Possible Values?

I have a worksheet where data has been entered from a userform. For each entry, there is a separate reference number in the form of contract number-schedule number-machine type-cage number (e.g. 123-123-ABC-1).

The machien type will not always be known so the user will need to do a search for the contract number-schedule number and then bring up all the possible reference numbers.

For example this could look like:
123-123-ABC-1
123-123-ABC-2
123-123-CDE-1
123-123-CDE-2

I would like this list of all possible values to pop up.

what look up function would work and how I can do this?