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!


    • Example1.xlsx

      (8.94 kB, downloaded 14 times, last: )
    • Example2.xlsx

      (9.35 kB, downloaded 11 times, last: )