[URL] Worldwide Content Releastionship

<p>Note: there is no sample file for this video (the dataset is rather large, but feel free to make some random data in Excel to test the concepts yourself).</p>

<ul>
	<li>Fastest lookup formula in Excel!</li>
	<li>Dataset and testing methodology</li>
	<li>Writing the VLOOKUP formula</li>
	<li>INDEX MATCH formula</li>
	<li>Faster INDEX MATCH formulas</li>
	<li>XLOOKUP formula</li>
	<li>The results (calculation time)</li>
	<li>File size comparison</li>
	<li>What does it all mean?</li>
</ul>

I wrote 11 million formulas to find which one faster (XLOOKUP vs. INDEX MATCH)

EN Main Home

Constantly the latest news, events and article about Microsoft 365 and Azure.

HubSite 365 - The network about Microsoft 365 and Azure.

EN Main Events

EN Main Dashboard

EN Main Role Pro Office 365

EN Main Role Citizen Developer

EN Main Role Data Analytics

EN Main Role Azure Datacenter

EN Main My365

EN Main Content

EN Main Search

EN Main News

EN Main Know-How

#More-News

How to create a link to a specific approval request in Power Automate

Join Hub Site with Power Automate

Dataverse – Azure Aware Plugin + Service Bus Queue + Azure Function + Dataverse Custom API

Send SMS with Mac or Windows PC

Copilot for Power Apps Demo #shorts

Awesome Excel Formula by Example

Azure Synapse Analytics: Data Flows

How to create a People Picker in Power Apps

Power Pages code editing improvements with Visual Studio Code

#Top-News

Excel vs Power BI compared

Microsoft 365 Copilot System

LIVE A deep dive into Microsoft Loop and its components

SUPERCHARGE VISUALS in Power BI | Add KPIs to Titles

Scottish AI Summit

Microsoft Community Speakers

European Collaboration Summit 2023

Microsoft Build 2023

365 EduCon DC

EPPC European Power Platform Conference

Commsverse 2023

Events Slider Top 01

Breaking News 01

<h2>⚡ Microsoft announces Loop - All Videos and News</h2><p>Microsoft Loop is the next-generation cocreation experience that brings together teams, content, and tasks across your apps and devices.</p>

Microsoft announces Loop - All Videos and News

Footer01

Media of the Month 01

Empower Comms with Viva Engage + Microsoft 365 Copilot

Azure Infrastructure Weekly Update - 24th March 2023

How to Write Power Query if Statements incl. Nested ifs, if or, if and

Power Platform Connections Ep 6 - Shane Young

What's NEW in Microsoft 365 for March & April 2023

HomeAnnouncementSPContent01

[URL] German Content Relationship

[URL] EU Content Relationship

WebSite Community - Web EN

/crm-pages/i-wrote-11-million-formulas-to-find-which-one-faster--xlookup-vs.-index-match-.htm

I wrote 11 million formulas to find which one faster (XLOOKUP vs. INDEX MATCH)

Ever wonder what is the fastest lookup function in Excel? In this experiment style video, I test VLOOKUP vs. INDEX+MATCH vs. XLOOKUP by writing 11 million formulas. The results are surprising!