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
Microsoft Excel Excel Tips and Tricks
34K views · 517 reactions | Convert Excel into PDF | Microsoft Excel | Tips and tricks of Excel | Subscribe Youtube Channel for more videos https://youtube.com/@excelexpert7 #Excel #exceltips #exceltricks #excelexpert #excelprofessional #learnexcel #foryou #foryourpage #exceltraining #exceltutorial | Excel Expert | Facebook
0:34
34K views · 517 reactions | Convert Excel into PDF | Microsoft Excel | Tips and tricks of Excel | Subscribe Youtube Channel for more videos https://youtube.com/@excelexpert7 #Excel #exceltips #exceltricks #excelexpert #excelprofessional #learnexcel #foryou #foryourpage #exceltraining #exceltutorial | Excel Expert | Facebook
FacebookExcel Expert
16.5K views3 weeks ago
3.1M views · 33K reactions | Microsoft Excel Tips and Tricks l excel shorts #msexcel #advancedexcenewfunction #excel #famousfood | Ather Naqvi | Facebook
2:51
3.1M views · 33K reactions | Microsoft Excel Tips and Tricks l excel shorts #msexcel #advancedexcenewfunction #excel #famousfood | Ather Naqvi | Facebook
FacebookAther Naqvi
1.1M views3 weeks ago
1M views · 27K reactions | Awesome Microsoft #Excel & Google Sheets | Tips & Tricks | Excel Basement | Facebook
4:09
1M views · 27K reactions | Awesome Microsoft #Excel & Google Sheets | Tips & Tricks | Excel Basement | Facebook
FacebookExcel Basement
1M views1 week ago
Top videos
How to use INDEX and MATCH
How to use INDEX and MATCH
exceljet.net
1 year ago
Index Match Formula
Index Match Formula
corporatefinanceinstitute.com
2 months ago
INDEX and MATCH exact match
INDEX and MATCH exact match
exceljet.net
Aug 13, 2024
Microsoft Excel Excel Formulas
101 Advanced Excel Formulas & Functions Examples
101 Advanced Excel Formulas & Functions Examples
myexcelonline.com
127K viewsMar 3, 2021
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
MSN
15:23
MSN
MSNHowfinity
11 months ago
How to use INDEX and MATCH
How to use INDEX and MATCH
1 year ago
exceljet.net
Index Match Formula
Index Match Formula
2 months ago
corporatefinanceinstitute.com
INDEX and MATCH exact match
INDEX and MATCH exact match
Aug 13, 2024
exceljet.net
Index and match on multiple columns
Index and match on multiple columns
May 11, 2024
exceljet.net
How to Use INDEX MATCH with Multiple Criteria in Excel (3 Easy Steps)
6:38
How to Use INDEX MATCH with Multiple Criteria in Excel (3 Easy S…
138.6K viewsJan 31, 2024
YouTubeSpreadsheeto
Master the Index Match Function in Excel | Ultimate Guide for Data Lookup
1:29
Master the Index Match Function in Excel | Ultimate Guide for Data Lo…
2.8K viewsJan 21, 2025
YouTubeBright Minds Hub
Excel INDEX / MATCH Function for an Advanced Lookup
12:00
Excel INDEX / MATCH Function for an Advanced Lookup
94.9K viewsOct 9, 2017
YouTubeComputergaga
5:04
How to use the MATCH function in Excel
326.6K viewsAug 3, 2021
YouTubeTechOnTheNet
1:00
INDEX-MATCH function explained in UNDER a Minute! (Excel 2021)
3.1K viewsFeb 20, 2021
YouTube1MinuteTechHacks
9:25
Index Match Function in Excel - Step by Step Tutorial
2.2K viewsJun 21, 2021
YouTubeWallStreetMojo
5:32
How to use Index Match Formula in Microsoft Excel | Index Match Fun…
9.6K views8 months ago
YouTubeStudySpan
9:57
Match() and Index() Functions in Excel - Thorough Explanation
197.4K viewsAug 31, 2008
YouTubeTeachExcel
11:32
How to use Excel Index Match (the right way)
3.9M viewsMar 4, 2017
YouTubeLeila Gharani
10:47
Excel: INDEX and MATCH
256.1K viewsFeb 8, 2021
YouTubeTechnology for Teachers and Students
0:55
How to Use Index & Match Function in Excel with Multiple Criteria | Ex…
23.7K viewsJul 18, 2024
YouTubeAIC Certified Accountants
9:13
INDEX and MATCH Functions in Excel to Return Value in Different …
185.1K viewsApr 9, 2016
YouTubeDr. Todd Grande
4:16
Index Match Formula using Dynamic Drop-down list in Microsoft Excel …
46K viewsSep 7, 2023
YouTubeStudySpan
0:53
Mastering Index and Match Functions in Excel
37.4K views8 months ago
TikTokcheatsheets
8:52
How to use Index Match functions in Excel Microsoft Office 365
2K viewsJun 27, 2022
YouTubeExcel Dude Microsoft Excel & Office 365 Tutorials
3:39
XLOOKUP VS INDEX-XMATCH BY EXCEL IN A MINUTE
16.2K viewsJul 19, 2021
YouTubeExcel in a Minute
5:07
Excel Index Match Tutorial
1.2M viewsNov 4, 2017
YouTubeTEKNISHA
20:33
INDEX Function in Excel - Complete Guide | 5 Examples
20.4K viewsJan 18, 2022
YouTubeComputergaga
21:00
19- Microsoft Excel Advanced Tutorials | Index & Match Functio…
771 viewsNov 21, 2024
YouTubeIT Plus
1:15
MS Excel - Match Function
779.5K viewsJan 15, 2018
YouTubeTutorialsPoint
8:25
Microsoft Excel | Index and Match in Excel | Nested functions based o…
3.8K viewsMay 3, 2020
YouTubeTechnical Portal
3:43
ONLY Excel pros use this INDEX MATCH trick 💡
43.1K viewsMay 16, 2023
YouTubeChandoo
2:39
MS Excel - Index Function
949.9K viewsJan 15, 2018
YouTubeTutorialsPoint
19:29
Excel INDEX + MATCH Formula Explained | Index Match का मैज…
648.8K viewsAug 5, 2023
YouTubeDeepak EduWorld
13:10
Index + Match Function in Excel - Father of Vlookup || Best Ever Exp…
829.7K viewsApr 30, 2018
YouTubeDeepak EduWorld
See more videos
Static thumbnail place holder