INDEX/MATCH more than 1 result available but only displaying the 1st result

Hi,

I have a main data table and this is used to pull the relevant information, I have the majority of this working just one small issue.

The check table will frequently have the same KWO more than once as the order is a two part check i.e Rack & Cable

With my standard go to INDEX/MATCH formula it gives me the first result every time. (as expected)
However I need the formula to provide the unique type identifiers.

I have tried various formulas but none are what I need most just give me a list of types based on the first KWO it finds.
These tables will constantly be evolving and more data added to them so I need it to be flexible to a large degree.

P.S attached file is a stripped down version due to work confidentiality.

Thanks
Mark

Thanks for the swift replies.

I have opted to use Glenn's formula as it suits my needs better.
nflsales your formula works perfect on the sample data but when added to my main file its randomly picks and chooses which cells to populate with data in the order type column