I have two excel sheets with same column Names and Format. And it has one identical row(can use as Primary Key) id
. I want to get the diff.
table 1:
id Name GPA
----+------+-------
1 | AA | 3
2 | BB | 2
3 | CC | 3
4 | DD | 1
Table 2:
id Name GPA
----+------+-------
4 | DD | 2 (updated)
7 | YY | 2 (New)
1 | AA | 3 _
2 | DD | 2 (Updated)
Result Table:
id Name GPA
----+------+-------
4 | DD | 2
7 | YY | 2
2 | DD | 2
I want to populate the result table with only Updated and New Rows. (We can identify row using Primary key)
Is there any function directly to get the difference in Excel(VLOOKUP) ?
If not how can I write a query in Access to get this done?