You may be familiar with HLOOKUP & VLOOKUP, both of which are incredibly useful when it comes to looking for and returning sets of data. Excel have now introduced XLOOKUP. This modern replacement will see HLOOKUP & VLOOKUP be overtaken by the powerful XLOOKUP. If you use either HLOOKUP or VLOOKUP you’ll know that on occasion it can be different to get the result you expect. Now, with XLOOKUP, the process has been streamlined to provide you with three straightforward criteria. The three criteria are: lookup_value (what you are looking for); lookup_array (where to find it); return_array (what to return).
There are some issues with VLOOKUP that XLOOKUP solves. You cannot search for items toward the left of your data, only to the right. Whilst most formulas and functions will update when you add columns or rows in, VLOOKUP will not do this, potentially causing problems.
It may not mean much to those not well versed in Excel, but regardless, this is a change that cannot be understated. Searching for and returning data in your spreadsheets will now be a whole lot easier. All the potential obstacles and issues that other solutions (INDEX/MATCH) provide. will be removed. There are some optional criteria that allow you to make some adjustments to the returned values, that unlike H&VLOOKUP, allow you to refine and return more exact results.