Which is faster XLOOKUP or INDEX MATCH?

Access Analytic March 8, 2020
Video Thumbnail
Access Analytic Logo

Access Analytic

View Channel

About

Amazing Excel and Power BI Solutions. Perth, Western Australia. Our aim is to help you make decisions with confidence. Let us know if there's topics you'd like to cover and please subscribe and click the notification item to keep informed when we release new videos. About Us... Jeff Robson, Wyn Hopkins are the directors of Access Analytic Jeff is the founding Director and Principal Business Analyst at Access Analytic Solutions. He has over 20 years’ experience in chartered accounting, business management and consulting. Wyn is a Microsoft MVP and was once upon a time a Chartered Accountant with PricewaterhouseCoopers in the UK. He published the book Power BI for the Excel Analyst (a beginners guide to Power BI) in July 2022: https://pbi.guide Find out more about us and the team here https://accessanalytic.com.au/about-us-2-2/ Both Jeff and Wyn would love to connect up with you on LinkedIn https://www.linkedin.com/in/wynhopkins/ https://www.linkedin.com/in/jeffrobson/

Video Description

2,000,000 (yep that's million) XLOOKUP and INDEX MATCH formulas? Which is faster XLOOKUP or INDEX MATCH? I discovered some surprising aspects of Dynamic Array Excel during the creation of this video. And yes...I know I should use Power Query merges or Power Pivot relationships for this size of task 😁 XLOOKUP - what is it and how did it come about? https://accessanalytic.com.au/xlookup/ The easy way to do INDEX MATCH https://youtu.be/cT6K8Gz97PE https://accessanalytic.com.au/blog/

You May Also Like