How to use Index Match in Microsoft Excel

This is an educational video describing Index-Match functions in Microsoft Excel.

Description: 00:45
Example (Index): 02:00
Example (Match): 04:00
Example (Index-Match): 06:40
Comparison between VLOOKUP and Index-Match: 09:15

INDEX function helps to locate a cell in a table array based on row number and column number and return the value in that cell.

MATCH function helps us to find the row number and column number. It returns row number based on lookup value in a lookup array which in a column. It also returns column number based on lookup value in a lookup array which in a row.

INDEX & MATCH can perform two-way lookups by both looking along the rows and along the columns to find the intersection within a matrix.

Unlike VLOOKUP, which searches only to the right, INDEX and MATCH can look in both directions – left and right. Video related to VLOOKUP cab be accessed here

You may explore the following playlists:
Excel Chart ► https://www.youtube.com/playlist?list=PL4_t0woTUPVdC9MEOCst5lEbf2i_p3Gyy

Excel Advanced Functions ► https://www.youtube.com/playlist?list=PL4_t0woTUPVeP7sqSUsRWDe7sXYMuzZ99

Let’s be social at:
LinkedIn: https://www.linkedin.com/company/learning-home
Facebook: https://www.facebook.com/learninghome1
Twitter: https://twitter.com/LearningHome2

#Excel #ExcelTutorial #ExcelForBeginners

Видео How to use Index Match in Microsoft Excel канала Learning Home