I have two tables, with the same key values, as in the attached. The first is the original table (in the attached, tblOriginal), and the second table (tblChange) only contains some of the fields from the original. The end result that I want is to keep all the values from the original table except those values that appear in the second table, shown in tblResult.
It doesn't matter if it is a formula or power query - I'm just at a loss for the best way.
Thanks,
Bernie
Bookmarks