For those working in ad operations and PPC, the VLOOKUP function (and HLOOKUP – its horizontal counterpart) has been a tried-and-true staple of data manipulation in Excel. Now, after more than 34 years as a cornerstone lookup function, VLOOKUP is making way for a new successor.
Microsoft has announced the rollout of XLOOKUP – a powerful new function designed to address many of the known limitations of VLOOKUP. For advertisers and marketers, this means more efficient reporting with less time spent performing workaround functions.
How it works
XLOOKUP function is able to search sheets both vertically and horizontally, which wasn’t a possibility with VLOOKUP alone. XLOOKUP requires only three inputs in order to perform the most common exact lookup: