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

The ULTIMATE Index Match Tutorial (5 Real-World Examples)

The ULTIMATE Index Match Tutorial (5 Real-World Examples)

YouTubeKenji Explains

336.3K viewsJul 23, 2023

How to use Excel Index Match (the right way)

How to use Excel Index Match (the right way)

YouTubeLeila Gharani

3.9M viewsMar 4, 2017

INDEX MATCH Excel Tutorial

INDEX MATCH Excel Tutorial

YouTubeKevin Stratvert

538.3K viewsJul 14, 2021

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

INDEX and MATCH approximate match with multiple criteria

INDEX and MATCH approximate match with multiple criteria

Excel Functions Tutorial

What If You Knew the SECRET to Effortless Excel Row & Column Adjustments?

What If You Knew the SECRET to Effortless Excel Row & Column Adjustments?

YouTubeIICA Computer Education

2.2K views19 hours ago

How to create a Simple Checklist with Checkbox in Excel

How to create a Simple Checklist with Checkbox in Excel

YouTubeEndless Knowledge

2.1K views5 days ago

How to Auto-Apply Borders in Excel | Smart Formatting Using Conditional Formatting

How to Auto-Apply Borders in Excel | Smart Formatting Using Conditional Formatting

YouTubeIICA Computer Education

41.8K views5 days ago

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

INDEX and MATCH approximate match with multiple criteria

INDEX and MATCH approximate match with multiple criteria

Index Match Formula

Index Match Formula

corporatefinanceinstitute.com

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.4K viewsNov 12, 2020

YouTubeBitesize Excel

How to use Index and Match in Excel

How to use Index and Match in Excel

6.8K viewsMar 22, 2021

YouTubeMike's Office

INDEX and MATCH with multiple criteria || Excel Tips & Tricks || dptutorials

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

14.4K viewsNov 29, 2019

YouTubedptutorials

Row Column Lookup with multiple criteria using INDEX and MATCH f…

27.9K viewsMay 15, 2022

YouTubeFind Easy Solution

Excel INDEX / MATCH Function for an Advanced Lookup

94.8K viewsOct 9, 2017

YouTubeComputergaga

Look Up Values with INDEX and MATCH functions in Microsoft Excel

269.6K viewsNov 22, 2022

YouTubeTeacher's Tech

How to Use INDEX and MATCH with Multiple Criteria in Excel

12.2K viewsJun 4, 2019

YouTubeExcelchat

How to Use INDEX MATCH with Multiple Criteria in Excel (3 Easy S…

121.5K viewsJan 31, 2024

YouTubeSpreadsheeto

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.3K viewsFeb 28, 2018

YouTubeTeachExcel

INDEX and MATCH exact match

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

71.6K viewsSep 14, 2020

YouTubeInnozant

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

2.2K views10 months ago

YouTubeBright Minds Hub

How To JOIN DATA In Excel Using INDEX MATCH Functions

53.1K viewsNov 27, 2020

YouTubeAdam Finer - Learn BI Online

How to Use VLOOKUP and INDEX MATCH in Excel

94.2K viewsOct 26, 2017

YouTubeVertex42

How to use the MATCH function in Excel

320.4K viewsAug 3, 2021

YouTubeTechOnTheNet

Advanced index match with if function | excel multiple criteria | …

8.1K viewsJun 12, 2020

YouTubeRJS Info

INDEX MATCH Excel Tutorial

538.3K viewsJul 14, 2021

YouTubeKevin Stratvert

How to use Excel Index Match (match multiple criteria)

606 viewsDec 10, 2022

YouTubeITmistic

Two Column Lookup in Excel | INDEX MATCH Formula

7.6K viewsDec 29, 2021

YouTubeExcel Tutorial

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]

956 viewsNov 5, 2019

YouTubeeTrainer Box

Excel Index Match Function Tutorial (with 3 examples)

1.1K viewsJul 23, 2023

YouTubeDr. Saeed Faal

See more videos