I am working on a list that contains data that has to be matched with another file.
If i match the number on the other file i have to get the outcome of a different column on that same row.
However there will be multiple matches on the other file, some with the same outcome. I need to only get the unique outcomes and nothing i tried worked so far.
Can one of you excel magicians help me out please?
See attachments for an example, i am trying to match example 1 with example 2.
Many thanks in advance!