Formula to match multiple unique value's

  • Hello,

    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!

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!