Syncing Data Between Tables

I have two tables, Table 1 and Table 2, with different fields. When a specific record is populated in Table 2, I want the values of some of its fields to automatically appear in a corresponding record in Table 1where the cells were initially empty,  based on the primary fields of both tables, I’m calculating a total in Table 1 based on entries into records in several tables and need to have the total in Table1  automatically updated whenever the values change in the other tables. What is the best way to achieve this? IOW, what is the equivalent of XLOOKUP or Index Match in Airtable?