Index and Match Function - Search Videos

Two-way lookup with INDEX and MATCH

Two-way lookup with INDEX and MATCH

To lookup in value in a table using both rows and columns, you can build a formula that does a two-way lookup with INDEX and MATCH. In the example shown, the formula in J8 is: =INDEX(C6:G10,MATCH(J6,B6:B10,1),MATCH(J7,C5:G5,1)) Note: this formula is set to "approximate match", so row values and column values must be sorted.

Excel Index Match

INDEX & MATCH Functions Combo in Excel (10 Easy Examples)

INDEX & MATCH Functions Combo in Excel (10 Easy Examples)

INDEX MATCH Multiple Criteria in Rows or Columns

INDEX MATCH Multiple Criteria in Rows or Columns

INDEX and MATCH exact match

INDEX and MATCH exact match

Top videos

How to Use INDEX MATCH With Multiple Criteria in Excel

How to Use INDEX MATCH With Multiple Criteria in Excel

spreadsheeto.com

How to use INDEX and MATCH

How to use INDEX and MATCH

Excel formula: INDEX and MATCH with multiple criteria - Excelchat

Excel formula: INDEX and MATCH with multiple criteria - Excelchat

Excel Functions Tutorial

20 Advanced Excel Functions and Formulas (for Excel Pros)

20 Advanced Excel Functions and Formulas (for Excel Pros)

450 Excel Formulas & Functions with Examples – All in One Video!

450 Excel Formulas & Functions with Examples – All in One Video!

YouTubeExcel (A-Z)

626K viewsAug 24, 2018

101 Excel Functions you should know

101 Excel Functions you should know

How to Use INDEX MATCH With Multiple Criteria in Excel

How to Use INDEX MATCH With Multiple Criteria in Excel

spreadsheeto.com

How to use INDEX and MATCH

How to use INDEX and MATCH

Excel formula: INDEX and MATCH with multiple criteria - Excelchat

Excel formula: INDEX and MATCH with multiple criteria - Excelchat

INDEX and MATCH approximate match with multiple criteria

INDEX and MATCH approximate match with multiple criteria

Index Match Formula

Index Match Formula

corporatefinanceinstitute.com

INDEX and MATCH with multiple criteria

INDEX and MATCH with multiple criteria

Excel for beginners: INDEX and MATCH functions to lookup data from multiple tables

Excel for beginners: INDEX and MATCH functions to lookup data fr…

9.6K viewsNov 12, 2020

YouTubeBitesize Excel

How to use Index and Match in Excel

6.8K viewsMar 22, 2021

YouTubeMike's Office

INDEX Function

INDEX and MATCH with multiple criteria || Excel Tips & Tricks || dpt…

14.4K viewsNov 29, 2019

YouTubedptutorials

How to use Index Match in Excel | How Index Match Works | Comple…

5.1K viewsMar 20, 2020

YouTubeBlue Sun Channel

Excel INDEX / MATCH Function for an Advanced Lookup

94.9K viewsOct 9, 2017

YouTubeComputergaga

Look Up Values with INDEX and MATCH functions in Microsoft Excel

277.9K viewsNov 22, 2022

YouTubeTeacher's Tech

Index Match Function in Excel - Step by Step Tutorial

2.2K viewsJun 21, 2021

YouTubeWallStreetMojo

6 Incredible Excel INDEX/MATCH Lookup Examples - Workbook Incl…

435.6K viewsFeb 28, 2018

YouTubeTeachExcel

INDEX and MATCH exact match

Index & Match Functions- Excel Three Way Lookup using Index & …

71.9K viewsSep 14, 2020

YouTubeInnozant

Master the Index Match Function in Excel | Ultimate Guide for Data Lo…

2.6K viewsJan 21, 2025

YouTubeBright Minds Hub

How to Use VLOOKUP and INDEX MATCH in Excel

94.7K viewsOct 26, 2017

YouTubeVertex42

How to use the powerful INDEX MATCH functions in Excel

1.3K views10 months ago

YouTubeExcel Helps

INDEX MATCH Excel Tutorial

553.3K viewsJul 14, 2021

YouTubeKevin Stratvert

How to use Excel Index Match (match multiple criteria)

619 viewsDec 10, 2022

YouTubeITmistic

Two Column Lookup in Excel | INDEX MATCH Formula

7.6K viewsDec 29, 2021

YouTubeExcel Tutorial

How To Use INDEX MATCH In A Table With INDIRECT In Excel

26.6K viewsJul 16, 2015

YouTubeExcel Bytes

How to use the index match function in Excel.

57.3K viewsNov 23, 2015

YouTubeBarb Henderson

INDEX-MATCH function explained in UNDER a Minute! (Excel 2021)

3.1K viewsFeb 20, 2021

YouTube1MinuteTechHacks

Excel - using match and index functions together

2.6K viewsAug 22, 2019

Index Match Excel Function Tutorial [With Examples]

960 viewsNov 5, 2019

YouTubeeTrainer Box

Excel Index Match Function Tutorial (with 3 examples)

1.1K viewsJul 23, 2023

YouTubeDr. Saeed Faal

See more videos