The XLOOKUP or VLOOKUP choice is tied to scenario, as most needs are fixed lookups, letting you save time with the simpler ...
After the fact, I could easily set a field in one table to look up data from another to join fields in different tables. Automating this from imports of existing data worked quite well when there was ...