We suggest XLOOKUP as the best solution (INDEX-MATCH for non-O365 users), but as you can see, there are many ways to get to the right answer. You can find more ways to solve this problem, such as creating your own lookup function using VBA. In total, we presented you with 12 ways to solve the Retail Inventory Review case. In the following example, you will get the value of the cell in the 4th row and 2nd column in A1:B5 range. INDEX will give you the exact value of the cell in a known position. By nesting the MATCH formula in INDEX, you can replace VLOOKUP in a much more robust way. INDEX formula provides you with the exact location of a cell in a range. We’ll start with most often promoted alternative (at least until XLOOKUP was launched) INDEX-MATCH and then go through each alternative one by one.ġ) INDEX-MATCH: If you don’t have an Office 365 subscription, INDEX-MATCH is your best alternative to VLOOKUP. In terms of complexity, we recommend that you choose simpler and faster solutions. Some of these alternatives are superior to others in terms of calculation and speed, whilst some are not recommended. This week, we are going to discuss 10 other alternatives to VLOOKUP. Last week, we discussed the best way to achieve our goal instead of the flawed formula VLOOKUP: the answer was XLOOKUP. That’s why Serdar and I have set out to be formula busters moving you away from simple yet poor solutions to find better yet still simple solutions! Not because it’s complex but because we learn a set of base formulas from the beginning and find it very hard to move on from them when presented with a better alternative. Picking the right formula to solve any given problem in Excel is quite hard. This article is co-written by Serdar Barbaros Ozsoy and Anders Liu-Lindberg You can subscribe too and receive my weekly blog directly in your inbox. This is the channel "Here's the Future of FP&A and Business Partnering" with more than 11,000 subscribers. You can go follow me there by clicking here. Things are heating up on Instagram where I share my entrepreneur story, what consultant life is like, and give a behind the scenes look at the Business Partnering Institute.