How to use EXCEL INDEX and MATCH Function!

Показать описание

How to use EXCEL INDEX and MATCH Function!

INDEX and MATCH is a more powerful LOOKUP function than VLOOKUP. One of the biggest issues with using VLOOKUP is that it uses a static column reference. On the other hand, INDEX MATCH uses dynamic column and row reference. The INDEX function returns a value of a cell in an array, at the intersection of a row and column that you provided. The Match function looks up a numeric or text value in an array, and returns the position of it within the array. In this video, you will learn how to use EXCEL’s INDEX and MATCH functions individually to understand how they work, and then we will write the INDEX and MATCH formula together!

If you find the video useful, subscribe to “The HR Diary” YouTube channel. Subscribing to YouTube channels is free, and you will be updated when new contents are uploaded.

Other related resources to this video:
~ How to Use XLOOKUP in EXCEL!
~ XLOOKUP vs VLOOKUP vs HLOOKUP
~ XLOOKUP vs INDEX & MATCH
~ How to use IFERROR in EXCEL
~ How to use HLOOKUP in EXCEL!
~ How to show formulas with FORMULATEXT Function!
~ What is COMPA RATIO and how do you use it for pay decisions?
~ How to create a MERIT MATRIX to allocate salary increases!
~ How to create a SALARY INCREASE MATRIX with EXCEL!
~ How to use EXCEL INDEX Formula!
~ How to use EXCEL MATCH Function!
~ How to use SLICERS in EXCEL TABLE!
~ How to find PERCENTILE in PIVOT TABLE
~ How to create a 9 BOX GRID for TALENT MAPPING with SCATTER CHART!
~ COUNT FUNCTIONS IN EXCEL (COUNT, COUNTA, COUNTBLANK, COUNTIF, COUNTIFS)

By Cedric Ng,
AUTHOR of International Best Sellers,
“Predictive HR Analytics, Text Mining & ONA with Excel” &
“IISS: Employee Experience & Engagement with Predictive Analytics”