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
54.2K viewsNov 27, 2020
Microsoft Excel Excel Tips and Tricks
Excel for Dummies: Our Top Tips | GoSkills
Excel for Dummies: Our Top Tips | GoSkills
goskills.com
Jul 20, 2020
Microsoft Excel: Easy guide for beginners with formulas and more
11:12
Microsoft Excel: Easy guide for beginners with formulas and more
hubspot.com
Sep 4, 2024
21 Excel Tips and Tricks to Make You a PRO in 2024 (Free PDF)
21 Excel Tips and Tricks to Make You a PRO in 2024 (Free PDF)
excelchamps.com
Jul 24, 2024
Top videos
INDEX & MATCH Functions Combo in Excel (10 Easy Examples)
5:51
INDEX & MATCH Functions Combo in Excel (10 Easy Examples)
trumpexcel.com
Mar 6, 2019
Excel formula: INDEX and MATCH with multiple criteria - Excelchat
2:16
Excel formula: INDEX and MATCH with multiple criteria - Excelchat
got-it.ai
Nov 1, 2018
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 Functions Combo in Excel (10 Easy Examples)
5:51
INDEX & MATCH Functions Combo in Excel (10 Easy Examples)
Mar 6, 2019
trumpexcel.com
Excel formula: INDEX and MATCH with multiple criteria - Excelchat
2:16
Excel formula: INDEX and MATCH with multiple criteria - Excelchat
Nov 1, 2018
got-it.ai
How to use INDEX and MATCH
How to use INDEX and MATCH
11 months ago
exceljet.net
How to use INDEX and MATCH with a table
How to use INDEX and MATCH with a table
Oct 27, 2022
exceljet.net
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 Formula
Index Match Formula
2 months ago
corporatefinanceinstitute.com
INDEX and MATCH with multiple criteria
INDEX and MATCH with multiple criteria
May 12, 2024
exceljet.net
6:09
Excel for beginners: INDEX and MATCH functions to lookup data fr…
9.6K viewsNov 12, 2020
YouTubeBitesize Excel
3:31
Multiple criteria lookup using INDEX and MATCH functions in Excel - O…
17.5K viewsMay 10, 2022
YouTubeFind Easy Solution
15:10
How to Use INDEX MATCH Lookups in Excel - Step by Step Guide
8.4K viewsJul 23, 2019
YouTubeTeachExcel
INDEX Function
Aug 30, 2024
exceljet.net
Index and match on multiple columns
May 11, 2024
exceljet.net
INDEX and MATCH exact match
Aug 13, 2024
exceljet.net
INDEX and MATCH approximate match with multiple criteria
Mar 22, 2023
exceljet.net
7:26
How to use Index and Match in Excel
6.8K viewsMar 22, 2021
YouTubeMike's Office
2:37
INDEX and MATCH with multiple criteria || Excel Tips & Tricks || dpt…
14.4K viewsNov 29, 2019
YouTubedptutorials
15:46
Index & Match Functions- Excel Two Way Lookup using Index & Match …
51.6K viewsSep 11, 2020
YouTubeInnozant
4:21
How to Perform INDEX & MATCH with MULTIPLE Criteria in Excel!
34.6K viewsMar 2, 2024
YouTubeAnser's Excel Academy
2:08
Index Match Excel Function Tutorial [With Examples]
960 viewsNov 5, 2019
YouTubeeTrainer Box
4:33
How to use Excel Index Match (match multiple criteria)
619 viewsDec 10, 2022
YouTubeITmistic
9:55
Look Up Values with INDEX and MATCH functions in Microsoft Excel
279.2K viewsNov 22, 2022
YouTubeTeacher's Tech
2:42
How to use the index match function in Excel.
57.3K viewsNov 23, 2015
YouTubeBarb Henderson
4:38
Add Lookups both VERTICALLY AND HORIZONTALLY in Excel (IN…
8.9K viewsDec 12, 2022
YouTubeEssentials Explained
9:25
Index Match Function in Excel - Step by Step Tutorial
2.2K viewsJun 21, 2021
YouTubeWallStreetMojo
15:29
INDEX MATCH Excel Tutorial
557.4K viewsJul 14, 2021
YouTubeKevin Stratvert
12:00
Excel INDEX / MATCH Function for an Advanced Lookup
94.9K viewsOct 9, 2017
YouTubeComputergaga
4:05
Index match with multiple criteria | excel multiple columns match
62.9K viewsOct 29, 2020
YouTubeRJS Info
2:50
Row Column Lookup with multiple criteria using INDEX and MATCH f…
28K viewsMay 15, 2022
YouTubeFind Easy Solution
25:10
6 Incredible Excel INDEX/MATCH Lookup Examples - Workbook Incl…
435.6K viewsFeb 28, 2018
YouTubeTeachExcel
See more videos
Static thumbnail place holder