Okebiz Video Search



Title:INDEX MATCH Explained (An Alternative to VLOOKUP)
Duration:19:28
Viewed:347,023
Published:02-10-2019
Source:Youtube

In this video I explain how to use the INDEX MATCH formula as an alternative to VLOOKUP in Excel. Download the Excel file: https://www.excelcampus.com/functions...

You can follow along with the video and practice writing the formulas. The Excel file also includes my cheat sheet for writing the formulas.

I explain the two main benefits of INDEX MATCH over VLOOKUP. This includes:

The ability to return a value from a column to the left/above.
Separate columns for the lookup and return ranges.
We also look at the most common error that the formula returns and how to prevent it.

The new XLOOKUP function is another alternative to VLOOKUP and INDEX MATCH. Check out my other videos for more details on that.

VLOOKUP Explained: https://www.youtube.com/watch?v=d3BYV...
XLOOKUP Explained: https://www.youtube.com/watch?v=txK0C...
XLOOKUP Explained in 3 Minutes: https://www.youtube.com/watch?v=txK0C...
Excel Tables for Beginners: https://youtu.be/fJnJTff4Na8

#MsExcel #ExcelCampus

SHARE TO YOUR FRIENDS


Download Server 1


DOWNLOAD MP4

Download Server 2


DOWNLOAD MP4

Alternative Download :



SPONSORED
Loading...
RELATED VIDEOS
☑️ Top 30 Advanced Excel Tips and Tricks ☑️ Top 30 Advanced Excel Tips and Tricks
10:56 | 328,848
The New XLOOKUP Function: Compared to VLOOKUP & INDEX MATCH in Excel The New XLOOKUP Function: Compared to VLOOKUP &...
20:55 | 62,524
How to use Excel Index Match (the right way) How to use Excel Index Match (the right way)
11:32 | 687,264
VLOOKUP Tutorial for Excel - Everything You Need To Know VLOOKUP Tutorial for Excel - Everything You Nee...
21:50 | 622,001
Power Query Overview - Automate Data Tasks in Excel & Power BI Power Query Overview - Automate Data Tasks in E...
15:52 | 98,197
Excel VBA Beginner Tutorial Excel VBA Beginner Tutorial
10:31 | 979,372
Secrets to Building Excel Dashboards in Under 15 Minutes! Secrets to Building Excel Dashboards in Under 1...
13:20 | 108,518
19 Advanced Excel Shortcuts (do you know them all?) 19 Advanced Excel Shortcuts (do you know them a...
10:38 | 70,576