Mapping in Excel

  • Hi there,

    I hope you all are doing great.

    I am a beginner in Excel, so I would like to ask you for little help with which formula to use for mapping.

    My task is to map all available accounts from the operational system to the old CRM accounts and provide mapping between Customer Code and Account Master IDs, respectively. Since the data was maintained in two different systems, the same customer may exist in both but with different IDs and details. All matches should be found.

    You can find attached the file.

    Thank you in advance.

    Best regards,


  • Looks like you are also trying to get us to do your homework

    Read the Forum Rules


    5b. No asking for help with homework or college assignments. We will not do it for you. This also applies to the hire Help forum.