Linking data by Primary Column

YDB_UKuserlearning24

We track data for customer accounts in a couple of different categories. This inevitably means that some customers (not all) appear in both data sets.

We spend some time ensuring that the data entered is consistent across both, but this is a manual check. It'd be good to be able to 'link' data between sheets conditional on the reference in the Primary Column (a bit like an XLOOKUP/VLOOKUP function in excel). That way anything updated on one sheet will automatically update on the other.