Two-way lookup with INDEX and MATCH
exceljet.net
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.
Apr 4, 2023
Excel Index Match
Index and Match in Excel In this tutorial you'll learn how to use Index and Match in Excel to lookup data! #excel #exceltips #exceltricks #spreadsheets #corporate #workhacks #AccountingProfessionals | LEARN MORE
0:49
Index and Match in Excel In this tutorial you'll learn how to use Index and Match in Excel to lookup data! #excel #exceltips #exceltricks #spreadsheets #corporate #workhacks #AccountingProfessionals | LEARN MORE
FacebookLEARN MORE
27.7K views3 months ago
Learn how to use INDEX MATCH in Excel with 3 criteria for powerful lookups. This tutorial is perfect for anyone who wants to go beyond VLOOKUP and master advanced Excel formulas. What you’ll learn: ✔ How INDEX MATCH works ✔ Adding multiple conditions to your lookup ✔ Real-world example step-by-step #Excel #IndexMatch #ExcelTips | KASH
0:28
Learn how to use INDEX MATCH in Excel with 3 criteria for powerful lookups. This tutorial is perfect for anyone who wants to go beyond VLOOKUP and master advanced Excel formulas. What you’ll learn: ✔ How INDEX MATCH works ✔ Adding multiple conditions to your lookup ✔ Real-world example step-by-step #Excel #IndexMatch #ExcelTips | KASH
FacebookKASH
23.8K views7 months ago
Index and match in excel Learn how to use index match in excel #Excel #exceltips #spreadsheet #workhacks #corporate #Accounting | LEARN MORE
0:59
Index and match in excel Learn how to use index match in excel #Excel #exceltips #spreadsheet #workhacks #corporate #Accounting | LEARN MORE
FacebookLEARN MORE
8.8K views2 months ago
Top videos
How to Use INDEX MATCH With Multiple Criteria in Excel
How to Use INDEX MATCH With Multiple Criteria in Excel
spreadsheeto.com
Jun 16, 2022
How to use INDEX and MATCH
How to use INDEX and MATCH
exceljet.net
Mar 14, 2025
Index Match Formula
Index Match Formula
corporatefinanceinstitute.com
3 months ago
Excel Tutorial
Pivot Table Excel Tutorial
13:36
Pivot Table Excel Tutorial
YouTubeKevin Stratvert
5M viewsMay 21, 2019
Introduction to Pivot Tables, Charts, and Dashboards in Excel (Part 1)
14:48
Introduction to Pivot Tables, Charts, and Dashboards in Excel (Part 1)
YouTubeExcel Campus - Jon
15.3M viewsFeb 4, 2015
MS Excel 2013 Tutorial FOR BEGINNERS PART 1 - How to use Excel - formulas, charts, tables
10:10
MS Excel 2013 Tutorial FOR BEGINNERS PART 1 - How to use Excel - formulas, charts, tables
YouTubeTodd Workman
649.7K viewsJun 19, 2013
How to Use INDEX MATCH With Multiple Criteria in Excel
How to Use INDEX MATCH With Multiple Criteria in Excel
Jun 16, 2022
spreadsheeto.com
How to use INDEX and MATCH
How to use INDEX and MATCH
Mar 14, 2025
exceljet.net
Index Match Formula
Index Match Formula
3 months ago
corporatefinanceinstitute.com
INDEX and MATCH with multiple criteria
INDEX and MATCH with multiple criteria
May 12, 2024
exceljet.net
Index and match on multiple columns
Index and match on multiple columns
May 11, 2024
exceljet.net
INDEX and MATCH exact match
INDEX and MATCH exact match
Aug 13, 2024
exceljet.net
Excel for beginners: INDEX and MATCH functions to lookup data from multiple tables
6:09
Excel for beginners: INDEX and MATCH functions to lookup data fr…
9.8K viewsNov 12, 2020
YouTubeBitesize Excel
INDEX and MATCH approximate match with multiple criteria
Mar 22, 2023
exceljet.net
15:10
How to Use INDEX MATCH Lookups in Excel - Step by Step Guide
8.4K viewsJul 23, 2019
YouTubeTeachExcel
3:18
How to do a two way lookup with INDEX and MATCH
48.9K viewsFeb 26, 2015
YouTubeExceljet
2:37
INDEX and MATCH with multiple criteria || Excel Tips & Tricks || dpt…
14.4K viewsNov 29, 2019
YouTubedptutorials
2:08
Index Match Excel Function Tutorial [With Examples]
960 viewsNov 5, 2019
YouTubeeTrainer Box
6:18
How To JOIN DATA In Excel Using INDEX MATCH Functions
54.4K viewsNov 27, 2020
YouTubeAdam Finer - Learn BI Online
4:38
Add Lookups both VERTICALLY AND HORIZONTALLY in Excel (IN…
9K viewsDec 12, 2022
YouTubeEssentials Explained
4:33
How to use Excel Index Match (match multiple criteria)
626 viewsDec 10, 2022
YouTubeITmistic
2:50
Row Column Lookup with multiple criteria using INDEX and MATCH f…
28K viewsMay 15, 2022
YouTubeFind Easy Solution
4:43
How to use Index Match in Excel | How Index Match Works | Comple…
5.1K viewsMar 20, 2020
YouTubeBlue Sun Channel
25:10
6 Incredible Excel INDEX/MATCH Lookup Examples - Workbook Incl…
435.9K viewsFeb 28, 2018
YouTubeTeachExcel
7:26
How to use Index and Match in Excel
6.8K viewsMar 22, 2021
YouTubeMike's Office
2:42
How to use the index match function in Excel.
57.3K viewsNov 23, 2015
YouTubeBarb Henderson
1:00
INDEX-MATCH function explained in UNDER a Minute! (Excel 2021)
3.1K viewsFeb 20, 2021
YouTube1MinuteTechHacks
12:00
Excel INDEX / MATCH Function for an Advanced Lookup
95K viewsOct 9, 2017
YouTubeComputergaga
3:59
How to Use VLOOKUP and INDEX MATCH in Excel
95K viewsOct 26, 2017
YouTubeVertex42
1:29
Master the Index Match Function in Excel | Ultimate Guide for Data Lo…
2.9K viewsJan 21, 2025
YouTubeBright Minds Hub
16:40
Using INDEX and MATCH to lookup data and using COUNTIF and COU…
23.8K viewsMar 26, 2020
YouTubeAlym Teaches
2:17
How to Use INDEX and MATCH with Multiple Criteria in Excel
12.2K viewsJun 4, 2019
YouTubeExcelchat
3:02
INDEX and INDEX MATCH Formulas Explained [SMARTSHEET]
12.4K viewsDec 15, 2020
YouTubeCheetah Transformation
9:55
Look Up Values with INDEX and MATCH functions in Microsoft Excel
282.8K viewsNov 22, 2022
YouTubeTeacher's Tech
15:29
INDEX MATCH Excel Tutorial
562.8K viewsJul 14, 2021
YouTubeKevin Stratvert
See more videos
Static thumbnail place holder