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
INDEX and MATCH Functions: Step-by-Step Tutorial
How to use the INDEX function in Excel
2:47
How to use the INDEX function in Excel
YouTubeTechOnTheNet
598.6K viewsOct 16, 2018
Using the MATCH Function in Microsoft Excel
3:16
Using the MATCH Function in Microsoft Excel
YouTubeSimon Sez IT
105.8K viewsJan 13, 2023
How To JOIN DATA In Excel Using INDEX MATCH Functions
6:18
How To JOIN DATA In Excel Using INDEX MATCH Functions
YouTubeAdam Finer - Learn BI
55.2K viewsNov 27, 2020
Microsoft Excel Excel Tips and Tricks
I'll Make You a Spreadsheet Pro. Try My 50 Favorite Excel Tricks
I'll Make You a Spreadsheet Pro. Try My 50 Favorite Excel Tricks
pcmag.com
3 weeks ago
Top 100 Excel Tips and Tricks to Make You Productive in 2026
Top 100 Excel Tips and Tricks to Make You Productive in 2026
excelchamps.com
Jul 24, 2024
Top 40 Excel Skills to Master (Basic, Intermediate, Advanced)
Top 40 Excel Skills to Master (Basic, Intermediate, Advanced)
trumpexcel.com
Aug 14, 2015
Top videos
How to use INDEX and MATCH
How to use INDEX and MATCH
exceljet.net
Mar 14, 2025
Excel formula: INDEX and MATCH with multiple criteria - Excelchat
2:16
Excel formula: INDEX and MATCH with multiple criteria - Excelchat
got-it.ai
Nov 2, 2018
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
Advanced Lookups with INDEX and MATCH
The ULTIMATE Index Match Tutorial (5 Real-World Examples)
11:53
The ULTIMATE Index Match Tutorial (5 Real-World Examples)
YouTubeKenji Explains
371.5K viewsJul 23, 2023
Index Match Advanced: 3 Most Effective Formulas for Multiple Criteria
10:22
Index Match Advanced: 3 Most Effective Formulas for Multiple Criteria
YouTubeLeila Gharani
1.1M viewsMar 9, 2017
4 Mins. to MASTER Excel INDEX & MATCH formulas!
4:40
4 Mins. to MASTER Excel INDEX & MATCH formulas!
YouTubeMyOnlineTrainingHub
549K viewsApr 13, 2023
How to use INDEX and MATCH
How to use INDEX and MATCH
Mar 14, 2025
exceljet.net
Excel formula: INDEX and MATCH with multiple criteria - Excelchat
2:16
Excel formula: INDEX and MATCH with multiple criteria - Excelchat
Nov 2, 2018
got-it.ai
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
Look Up Values with INDEX and MATCH functions in Microsoft Excel
9:55
Look Up Values with INDEX and MATCH functions in Microsoft Excel
288.2K viewsNov 22, 2022
YouTubeTeacher's Tech
How to use INDEX and MATCH with a table
How to use INDEX and MATCH with a table
May 11, 2018
exceljet.net
Index & Match Functions- Excel Two Way Lookup using Index & Match & Conditional Formatting
15:46
Index & Match Functions- Excel Two Way Lookup using Index & Match & Conditional Formatting
52.7K viewsSep 11, 2020
YouTubeInnozant
Multiple criteria lookup using INDEX and MATCH functions in Excel - Office 365
3:31
Multiple criteria lookup using INDEX and MATCH functions in Excel - Office 365
17.5K viewsMay 10, 2022
YouTubeFind Easy Solution
0:46
How to use index match with multiple criteria?
7K viewsAug 8, 2023
YouTubeGetFormula
6:09
Excel for beginners: INDEX and MATCH functions to lookup data from multiple tables
10K viewsNov 12, 2020
YouTubeBitesize Excel
10:47
Excel: INDEX and MATCH
257.5K viewsFeb 8, 2021
YouTubeTechnology for Teachers and Students
15:29
INDEX MATCH Excel Tutorial
579.4K viewsJul 14, 2021
YouTubeKevin Stratvert
5:32
How to use Index Match Formula in Microsoft Excel | Index Match Function in Excel
10K views10 months ago
YouTubeStudySpan
6:22
Excel Index Match Formula Tutorial | How to Use INDEX and MATCH Function in Excel [Step by Step]
129 views8 months ago
YouTubeTutorials for
2:37
INDEX and MATCH with multiple criteria || Excel Tips & Tricks || dptutorials
14.5K viewsNov 29, 2019
YouTubedptutorials
5:38
How to use the powerful INDEX MATCH functions in Excel
2.1K viewsApr 8, 2025
YouTubeExcel Helps
INDEX and MATCH with multiple criteria
May 12, 2024
exceljet.net
7:26
How to use Index and Match in Excel
7K viewsMar 22, 2021
YouTubeMike's Office
9:25
Index Match Function in Excel - Step by Step Tutorial
2.2K viewsJun 21, 2021
YouTubeWallStreetMojo
Index and match on multiple columns
May 11, 2024
exceljet.net
25:10
6 Incredible Excel INDEX/MATCH Lookup Examples - Workbook Included
436.4K viewsFeb 28, 2018
YouTubeTeachExcel
1:29
Master the Index Match Function in Excel | Ultimate Guide for Data Lookup
3K viewsJan 21, 2025
YouTubeBright Minds Hub
6:05
How to use Index Match Function in Microsoft Excel | Index Match Formula in Excel
21K viewsDec 23, 2024
YouTubeStudySpan
0:55
How to Use Index & Match Function in Excel with Multiple Criteria | Excel Formula Hacks
28.5K viewsJul 18, 2024
YouTubeAIC Certified Accountants
2:56
Excel - using match and index functions together
2.6K viewsAug 22, 2019
YouTubeCodible
5:09
Iferror And Index Match Functions
21.3K viewsSep 24, 2020
YouTubeAkerele Oluwasogo (Mr Excel)
5:43
Two Column Lookup in Excel | INDEX MATCH Formula
7.7K viewsDec 29, 2021
YouTubeExcel Tutorial
4:38
Add Lookups both VERTICALLY AND HORIZONTALLY in Excel (INDEX MATCH MATCH EXPLAINED)
9.2K viewsDec 12, 2022
YouTubeEssentials Explained
INDEX and MATCH exact match
Aug 13, 2024
exceljet.net
7:48
Excel Tutorial: How to Use INDEX and MATCH Functions for Data Retrieval
8K viewsJun 22, 2023
YouTubeKnowHow
See more