Okebiz Video Search



Title:How to use Excel Index Match (the right way)
Duration:11:32
Viewed:1,834,088
Published:04-03-2017
Source:Youtube

Check the Excel Essentials Course: https://courses.xelplus.com/p/learn-e...

Quickly learn all you need to know about INDEX & MATCH to get a quick start.
Complete Excel Dashboard course: https://courses.xelplus.com/p/profess...

Check out my other courses below.

Download workbook here: http://www.xelplus.com/excel-index-an...

How to do Index Match in Excel: The basics. Watch this video tutorial to find out how you can use Index & Match for more complex lookup problems. This video shows you how Index Match works with simple and to the point explanation. It first shows you how Index works on it's own and then how Match works and then puts the two Excel functions together.

Why index match is better than vlookup & why use index match
instead of vlookup?

Here are 3 reasons why Excel experts generally substitute VLOOKUP with INDEX and MATCH.
1. Unlike VLOOKUP, which searches only to the right, INDEX and MATCH can look in both directions – left and right.
2. INDEX & MATCH can perform two-way lookups by both looking along the rows and along the columns to find the intersection within a matrix.
3. INDEX & MATCH is less prone to errors. Assume you have a VLOOKUP where the final value you want returned is in column N. Your lookup value is in column A. You need to highlight the entire A to N range and then provide your index number to be 14. If you happen to delete any of the in-between columns, you would have to update that index number. You don’t need to worry about this when you use INDEX & MATCH.

All in all, INDEX and MATCH is more flexible than VLOOKUP.
Here are some of the reasons why Excel experts generally substitute VLOOKUP with INDEX and MATCH.

Note: Index match is not case sensitive

Index explained:

The first argument of INDEX is to give it an array. This array (range) should include your answer. You then need to specify how many rows to go down and how many columns to move to find the correct value. You cannot move outside the INDEX range.
The syntax of INDEX is:

• The range where the return value resides.
• Number of rows to move down (the row index)
• Number of columns to move to the right (the column Index). This argument is optional. If you only have one column, you can leave the column argument empty, otherwise, you need to specify the number of columns to move over, in the range.

The MATCH function’s syntax is as follows:

• Like VLOOKUP, Match needs a lookup (target) value. The user can reference a cell or directly type the value into the formula.
• Lookup_array: The “list” (range) where the return values are located.
• Match_type: 0 for an “exact” match.

Index MATCH used together:

When INDEX and MATCH are used together, the MATCH function finds the look up value’s row / column index and then hands this value off to the INDEX function to get the lookup value.

★ My Online Excel Courses ► https://www.xelplus.com/courses/

✉ Subscribe & get my TOP 10 Excel formulas e-book for free
https://www.xelplus.com/free-ebook/

EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/

Get Office 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327...

Time Stamps:
00:00 Is INDEX & MATCH the same as VLOOKUP?
00:52 Excel INDEX function explained
05:07 Excel MATCH function explained
06:29 Using INDEX & MATCH together
08:08 Two way lookup with INDEX & MATCH (data validation)
10:30 How to REALLY learn Excel INDEX & MATCH

GEAR
Screen recorder: http://techsmith.pxf.io/c/1252781/347...
Main Camera: https://amzn.to/3a5ldBs
Backup Camera: https://amzn.to/2FLiFho
Main Lens: https://amzn.to/39apgeD
Zoom Lens: https://amzn.to/3bd5pN7
Audio Recorder: https://amzn.to/2Uo5rLm
Microphone: https://amzn.to/2xYy9em
Lights: http://amzn.to/2eJKg1U

More resources on my Amazon page: https://www.amazon.com/shop/leilagharani

Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
Twitter: https://twitter.com/leilagharani
LinkedIn: https://at.linkedin.com/in/leilagharani

Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

#MsExcel

SHARE TO YOUR FRIENDS


Download Server 1


DOWNLOAD MP4

Download Server 2


DOWNLOAD MP4

Alternative Download :



SPONSORED
Loading...
RELATED VIDEOS
INDEX MATCH Explained (An Alternative to VLOOKUP) INDEX MATCH Explained (An Alternative to VLOOKUP)
19:28 | 451,501
Advanced Excel Index Match (3 Most Effective Formulas for Multiple Criteria) Advanced Excel Index Match (3 Most Effective Fo...
10:22 | 561,472
Create SMART Drop Down Lists in Excel (with Data Validation) Create SMART Drop Down Lists in Excel (with Dat...
15:42 | 191,728
Excel shortcut keys you SHOULD know! Excel shortcut keys you SHOULD know!
08:48 | 901,759
Key Consulting Excel Skills - How to use Index Match in Excel for Consultants Key Consulting Excel Skills - How to use Index ...
22:14 | 67,807
Lookup values across multiple worksheets: VLOOKUP / INDEX MATCH in Excel Lookup values across multiple worksheets: VLOOK...
13:10 | 438,446
Excel Complex Lookup: Find Header based on Lookup Criteria in Matrix with INDEX & SUMPRODUCT Excel Complex Lookup: Find Header based on Look...
10:44 | 124,275
Discover What XLOOKUP Can Do For YOU (R.I.P. Excel VLOOKUP) Discover What XLOOKUP Can Do For YOU (R.I.P. Ex...
06:59 | 701,912


coinpayu