Identify difference in value between two columns based on matching of unique identifier

I am pulling data from two different spreadsheets and need to identify changes in the value of a column between these two spreadsheets based on a common, unique identifier. I've written code to pull the data from the two spreadsheets. Attached is an example of what I'm trying to accomplish. Columns A-D come from one spreadsheet while Columns E-G. Column H should contain the formula to compare Columns C & G, based on the unique identified ID (Columns A & E), and to return "Yes" if no difference or "No" if there is a difference. I've tried to find a formula but it only works for the first two cases (ID 1 & 2). My formula in H2 is

Please Login or Register  to view this content.

I will eventually use this in VBA code, which I can easily do once I work out the formula. Any ideas?? Is there an easier way to do this in VBA? Thanks in advance!

Hi,

Here is an array formula that needs to be entered with SHIFT/CTRL/ENTER.

Please Login or Register  to view this content.

Hope this works for you and is helpful.

Cheers

Southward - Brilliant! Works perfect with some very minor tweaking. Thank you very much.

You are very welcome. Glad I could be of some assistance.

Cheers