Array Formula?

Status
Not open for further replies.

Domroy

Board Regular
Joined
Mar 8, 2018
Messages
89
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?
 

Some videos you may like

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.
Status
Not open for further replies.

Watch MrExcel Video

Forum statistics

Threads
1,096,287
Messages
5,449,459
Members
405,566
Latest member
JeIIyfish

This Week's Hot Topics

Top