Why INDEX MATCH is the Best Match for FP&A
Even VLOOKUP holdouts can't ignore that the benefits of Index Match clearly outweigh the downfalls when it comes to managing corporate budgets. Corporate budgeting requires managing a lot of moving parts and having reliable data and reports are table stakes. Index Match gives FP&A teams more confidence in their reports, reducing the potential for error, enabling better collaboration, and improving efficiency.
If you're interested in following the debate on Reddit, including the merits of other alternatives like XLOOKUP (available for Office 365 users) and PowerPivot (available via Excel plug-in), here are two links:
Of course, you can always reduce the Excel formulas that you need to create, by automating common FP&A reports. Cobbler helps FP&A teams automate BVA and headcount reporting. To learn more, schedule a demo.