Microsoft introduces XLOOKUP in Excel – and it’s a big deal for data reporting

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.
Xlookup

The new feature addresses many of VLOOKUP’s limitations.

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. 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:

XLOOKUP(lookup_value,lookup_array,return_array)

  • lookup_value: What you are looking for
  • lookup_array: Where to find it
  • return_array: What to return

Want to learn more?

Continue Reading

 

Share on facebook
Facebook
Share on twitter
Twitter
Share on linkedin
LinkedIn

0 Comments

Leave a Reply