XLOOKUP V's VLOOKUP - 8 Limitations Removed
Cross posted from my blog with SteemPress : http://theexcelclub.com/xlookup-in-excel-removes-these-8-limitations-of-vlookup/
![](https://steemitimages.com/640x0/http://theexcelclub.com/wp-content/uploads/2019/09/Compare-Excels-Vlookup-to-Xlookup.png)
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.
What’s Next?
We have loads of free resources to help you on your journey learning Excel
New to Excel? Check out our Ultimate beginner Excel Guide here.
New to Excel Power Tools? Check out these amazing Power Pivot, Power Query and Power view demonstrations
New to DAX for Power Pivot and Power BI? Let us help you get started
![Free Excel 365 basic course](https://steemitimages.com/640x0/https://i2.wp.com/theexcelclub.com/wp-content/uploads/2016/09/beginner-excel.png?resize=339%2C399)
![](https://steemitimages.com/640x0/https://i0.wp.com/theexcelclub.com/wp-content/uploads/2019/09/excel-365-formulas-course.png?resize=334%2C394&ssl=1)
Sign up for my newsletter – Don’t worry, I won’t spam. Just useful Excel and Power BI tips and tricks to your inbox with Earn and Learn activities.
SIGN UP NOW
![learn and earn steem activity](https://steemitimages.com/640x0/https://i1.wp.com/theexcelclub.com/wp-content/uploads/2019/05/steem.png?w=1170)
Enjoyed this Excel Article? Before you leave, it’s only fair that you share
Cross posted from my blog with SteemPress : http://theexcelclub.com/xlookup-in-excel-removes-these-8-limitations-of-vlookup/
Good stuff! I had a project that made extensive use of vlookup. I can't wait to try this new feature.
BTW, the newsletter sign-up page's "Sign Up Now" button leads to a bad page (the link from here works, though). I joined the site while I was there...
XLOOKUP rocks and it will make your spreadsheet using vlookup shrink a lot in size. Keey an eye out for next weeks post because I am going to post a useful video tutorial on XLOOKUP
Thanks for the heads up on the sign up button. Its seems to be working fine now....not sure what the problem was.
Here's the page it takes me to: https://theexcelclub.newzenler.com/f/undefined
ACE. I am looking forward to you releasing a video tutorial on this. Will xlookup be released back to Excel 2016 or will it only be on office 365?
I believe it is not backward compatible and will only be available in 365
Paula I was wondering when you were going to inform us about this. I have seen some articles on XLOOKUP on LinkedIn and I am eagerly awaiting the roll out to all Excel 365 subscribers. Any idea when we will get it? It looks superb!!!!!
Sup @dernan, as always thanks for stopping by. I'm sure you won't be too long waiting. I will let you know when it's available.
I don't find myself using Excel as much as I used to so it's handy to read about changes, I'd never have found this out otherwise.
I am glad you found some value in it. Excel is changing a lot and for the good, stay tuned, there is more to come :-)