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?
0 Comments