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.