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
591.1K viewsOct 16, 2018
Using the MATCH Function in Microsoft Excel
3:16
Using the MATCH Function in Microsoft Excel
YouTubeSimon Sez IT
99.1K 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 Online
50.7K viewsNov 27, 2020
Microsoft Excel Excel Tips and Tricks
Microsoft Excel Tips and Tricks l excel shorts #msexcel #advancedexcenewfunction #excel #famousfood | Ather Naqvi
2:51
Microsoft Excel Tips and Tricks l excel shorts #msexcel #advancedexcenewfunction #excel #famousfood | Ather Naqvi
FacebookAther Naqvi
1.1M viewsFeb 19, 2025
330K views · 14K reactions | 10 Awesome Microsoft #Excel Tips & Tricks | Excel Basement | Facebook
4:09
330K views · 14K reactions | 10 Awesome Microsoft #Excel Tips & Tricks | Excel Basement | Facebook
FacebookExcel Basement
330.5K views3 weeks ago
1M views · 11K reactions | FORMAT CELLS | Amazing tricks of Microsoft Excel | Data Entry Form |  #excel #exceltips #exceltricks #exceltutorial #spreadsheet #Formatcells #excelformula #data #search #dataentryform #fbviral | learn Excel with Bapi Sardar | Facebook
0:24
1M views · 11K reactions | FORMAT CELLS | Amazing tricks of Microsoft Excel | Data Entry Form |  #excel #exceltips #exceltricks #exceltutorial #spreadsheet #Formatcells #excelformula #data #search #dataentryform #fbviral | learn Excel with Bapi Sardar | Facebook
Facebooklearn Excel with Bapi Sardar
315.9K views2 weeks ago
Top videos
Index Match Formula
Index Match Formula
corporatefinanceinstitute.com
2 months ago
How to do a two way lookup with INDEX and MATCH
3:18
How to do a two way lookup with INDEX and MATCH
YouTubeExceljet
48.9K viewsFeb 26, 2015
How to use INDEX and MATCH
How to use INDEX and MATCH
exceljet.net
11 months ago
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
351K 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
506.2K viewsApr 13, 2023
Index Match Formula
Index Match Formula
2 months ago
corporatefinanceinstitute.com
How to do a two way lookup with INDEX and MATCH
3:18
How to do a two way lookup with INDEX and MATCH
48.9K viewsFeb 26, 2015
YouTubeExceljet
How to use INDEX and MATCH
How to use INDEX and MATCH
11 months ago
exceljet.net
Excel INDEX MATCH for Dummies: 2-Way Lookup Made Easy! 👽
1:00
Excel INDEX MATCH for Dummies: 2-Way Lookup Made Easy! 👽
89.2K viewsOct 3, 2024
YouTubeBright Minds Hub
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
INDEX & MATCH Functions Combo in Excel (10 Easy Examples)
5:51
INDEX & MATCH Functions Combo in Excel (10 Easy Examples)
Mar 6, 2019
trumpexcel.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
279.2K viewsNov 22, 2022
YouTubeTeacher's Tech
How to use INDEX and MATCH with a table
Oct 27, 2022
exceljet.net
15:46
Index & Match Functions- Excel Two Way Lookup using Index & Match …
51.6K viewsSep 11, 2020
YouTubeInnozant
0:46
239K views · 1.5K reactions | How to use Index and Match in Excel to g…
70.6K views2 weeks ago
FacebookLEARN MORE
3:31
Multiple criteria lookup using INDEX and MATCH functions in Excel - O…
17.5K viewsMay 10, 2022
YouTubeFind Easy Solution
6:09
Excel for beginners: INDEX and MATCH functions to lookup data fr…
9.6K viewsNov 12, 2020
YouTubeBitesize Excel
0:41
How to use Index and Match in Excel to lookup data! #excel #inde…
15.5K views2 months ago
YouTubeExcelbychris
0:28
74K views · 479 reactions | Learn how to use INDEX + MATCH in Ex…
22.4K views2 weeks ago
FacebookKASH
10:47
Excel: INDEX and MATCH
255.1K viewsFeb 8, 2021
YouTubeTechnology for Teachers and Students
0:43
Index Match in Excel‼️ #excel #exceltips #exceltricks #spreadsh…
29.2K viewsDec 30, 2024
FacebookCheatSheets
15:29
INDEX MATCH Excel Tutorial
557.4K viewsJul 14, 2021
YouTubeKevin Stratvert
0:57
How to Use INDEX and MATCH in Excel
52.7K viewsAug 27, 2024
YouTubeSimon Sez IT
2:37
INDEX and MATCH with multiple criteria || Excel Tips & Tricks || dpt…
14.4K viewsNov 29, 2019
YouTubedptutorials
2:20
How to Use INDEX MATCH in Excel - Easy Tutorial (2025)
627 views9 months ago
YouTubeEveryday Web
1:45
Excel INDEX MATCH Tutorial (Step-by-Step Guide) #excelshortcuts #e…
4.7K views10 months ago
YouTubeIDEA
5:38
How to use the powerful INDEX MATCH functions in Excel
1.4K views10 months ago
YouTubeExcel Helps
INDEX and MATCH with multiple criteria
May 12, 2024
exceljet.net
15:10
How to Use INDEX MATCH Lookups in Excel - Step by Step Guide
8.4K viewsJul 23, 2019
YouTubeTeachExcel
INDEX and MATCH approximate match with multiple criteria
Mar 22, 2023
exceljet.net
Mastering Index and Match Functions in Excel
37.4K views8 months ago
TikTokcheatsheets
7:26
How to use Index and Match in Excel
6.8K 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
See more videos
Static thumbnail place holder