traditional way of of looking up a dataset is VLOOKUP() and HLOOKUP() or INDEX() and MATCH(). However, XLOOKUP() is the modern approach.

We have a lookup table where based on GL Account, a Rate is assigned. A new column is added to the table in which Rate is acquired from the Lookup table using XLOOKUP() and dynamic array