Array Formula?

[Domroy]

Hi all,

I think I need an Array formula, and I'm not competent with those.

I have two documents I need to compare. Salesforce and KPHC. There are duplicate values

In Salesforce:
CustomerID - Column D
Address - Column U

In KPHC:
Customer ID - Column L
Address - Column E

There ARE duplicates in Customer ID. I'm hoping there's a way to compare Customer ID and address to see if there's an exact match. I'm really struggling with comparing the two...help?

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel-questions/1098034-index-match-formula.html#post5278874

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).