Part 5/8:
Our exploration extended to various lookup functions: VLOOKUP, INDEX & MATCH, and XLOOKUP. Each function was evaluated with both fixed and dynamic ranges across a dataset exceeding 107,000 rows. The time taken for all these functions to perform lookups was again measured in milliseconds, reinforcing the overall speed of the options available in Excel 2019 and later versions.
Additionally, XLOOKUP emerged as the fastest option when viewed as a spelled-out array, suggesting that utilizing this method could yield superior performance when managing lookup tasks.