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.
0 kommentar(er)
