Array Formula?

Status
Not open for further replies.

Domroy

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

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)
Status
Not open for further replies.

Watch MrExcel Video

Forum statistics

Threads
1,099,754
Messages
5,470,576
Members
406,707
Latest member
drkjz

This Week's Hot Topics

Top