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.