Index + Match formula?

[Domroy]

I have two files I need to compare. I am supposed to compare using the Customer ID number (in column D of my Salesforce doc). Unfortunately, there are multiple occurrences of these as there are multiple locations. I've been asked to match the customer ID AND address to make sure they're in sync. There's also a location ID field I could use, if necessary. I'm not great with array formulas, and I don't know "Index" very well. Can someone help me?

 

[RasGhul]

Can you post some sample data

 

[Domroy]

You know what, I had to find a workaround. So without a unique identifier, I put multiple numbers together and MADE one. Thank you, though!