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!