Excel LOOKUPs are powerful and versatile functions that save time and effort when working with large datasets. They are some of Excel’s most valuable and least understood functions. They search for specific values within a data range and return related information from another location. In this workshop, we will explore ways to return data using advanced techniques like VLOOKUP, XLOOKUP, NAMED RANGES, the MATCH and INDEX functions, and more.