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. It is rolling out for Office 365 Insiders Program users over the next few weeks.