XLOOKUP V's VLOOKUP - 8 Limitations Removed

XLOOKUP V's VLOOKUP

XLOOKUP, soon to be available in Excel 365 is going to make you rethink how you carry out your lookups. VLOOKUP comes with many limitations. Some of these limitations we can work around with other functions or combination of functions. But that is a pain…and time-consuming. Who needs all that hassle when XLOOK will remove these 8 limitations of VLOOKUP.

XLOOKUP V's VLOOKUP - 8 Limitation Removed

You cannot carry out an exact lookup by default with VLOOKUP – Guess what? you can with XLOOKUP. Exact lookup is the default setting in the new function.
You can not look up to the left with VLOOKUP – You can lookup to the left with XLOOKUP. As long as the arrays are of the same size (lookup array and return array), you can really lookup where you want.
You can't use VLOOKUP for a horizontal Lookup – You can carry out a horizontal Lookup with XLOOKUP.
Adding new columns to a table used in a VLOOKUP can break your formula. – You can add as many new columns with XLOOKUP as you like. There is no table array or column index to define in the next XLOOKUP.
It is not possible to search from bottom to top of a column with VLOOKUP – With XLOOKUP you can search from bottom to top.
Binary searches using VLOOKUP are not possible – You can with XLOOKUP.
You cannot carry out an approximate match if the table unless the table is sorted smallest to largest. You can carry out a XLOOKUP without sorting the table. This is an amazing step forward.
It is not possible to return an approximate match value that is higher using VLOOKUP. You can select to return an approximate match of a value higher with XLOOKUP. You can also select an approximate match of a lower value by default.

XLOOKUP is game-changer

XLOOKUP promises to be a game-changer when it comes to looking up values in Excel and returning a corresponding value. There are some many new features and function yet to be released in Excel 365 that will really blow your mind. XLOOKUP is for sure ranked high in the awesomeness of new releases.