This time, I show you how I look up data in a table using the XLOOKUP function.
In complex datasets, finding the unique values can sometimes be a bit of a challenge. While you can often simply remove duplicates, if you intend to create a lookup-table, that isn’t an option, and you need to do it differently. Enter the UNIQUE-function. For this example, assume that you want all unique entries in column…