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 views1 week ago
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 views4 weeks ago
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
Excel VLOOKUP function tutorial with formula examples
6:17
Excel VLOOKUP function tutorial with formula examples
ablebits.com
86.3K viewsAug 23, 2023
Lookup in a Table with Row and Column Criteria using INDEX and MATCH
9:26
Lookup in a Table with Row and Column Criteria using INDEX and MATCH
YouTubeExcel Insights
17.8K viewsApr 7, 2023
Look Up Values with INDEX and MATCH functions in Microsoft Excel
9:55
Look Up Values with INDEX and MATCH functions in Microsoft Excel
YouTubeTeacher's Tech
280.3K viewsNov 22, 2022
Microsoft Excel Excel Formulas
101 Advanced Excel Formulas & Functions Examples
101 Advanced Excel Formulas & Functions Examples
myexcelonline.com
127K viewsMar 3, 2021
Bring AI to your formulas with the COPILOT function in Excel
Bring AI to your formulas with the COPILOT function in Excel
Microsoft BlogsCatherine_Pidgeon
6 months ago
Subtraction in Microsoft Excel
0:42
Subtraction in Microsoft Excel
YouTubeMicrosoft 365
510K viewsOct 3, 2019
Excel VLOOKUP function tutorial with formula examples
6:17
Excel VLOOKUP function tutorial with formula examples
86.3K viewsAug 23, 2023
ablebits.com
Lookup in a Table with Row and Column Criteria using INDEX and MATCH
9:26
Lookup in a Table with Row and Column Criteria using INDEX and …
17.8K viewsApr 7, 2023
YouTubeExcel Insights
Look Up Values with INDEX and MATCH functions in Microsoft Excel
9:55
Look Up Values with INDEX and MATCH functions in Microsoft Excel
280.3K viewsNov 22, 2022
YouTubeTeacher's Tech
How to Find a Value in Table or Range in Excel using VLOOKUP
1:37
How to Find a Value in Table or Range in Excel using VLOOKUP
35.4K viewsMar 13, 2019
YouTubeNiyas C
Excel CHOOSE Function Examples
Excel CHOOSE Function Examples
Sep 25, 2024
contextures.com
Lookup value between two numbers
Lookup value between two numbers
Jun 17, 2022
exceljet.net
How to use an excel dropdown list and vlookup to auto-populate cells based on a selection
1:27
How to use an excel dropdown list and vlookup to auto-populate cell…
244.1K viewsFeb 17, 2017
YouTubeLonny Grafman
15:54
How to Extract Data from a Spreadsheet using VLOOKUP, MA…
5.4M viewsApr 22, 2014
YouTubeTuts+ Computer Skills
15:15
Index and Match Functions With Drop Down Lists | Excel
68.3K viewsJun 1, 2018
YouTubeThe Organic Chemistry Tutor
How to Select Cells with Differences in Excel - Excel Campus
Oct 30, 2019
excelcampus.com
Lookup Last Value in Column or Row – Excel
Feb 8, 2023
automateexcel.com
2:58
🗄 How to look for values in another table in Excel (INDEX + MATCH for…
115.9K viewsAug 9, 2021
YouTubeTemplate Dashboard - Excel
How to get the selected value of a slicer and list in a cell in Excel?
Sep 13, 2022
extendoffice.com
2:19
MS Excel: How to Select All Specific Value, Data & Cell (Easy)
69.3K viewsFeb 9, 2018
YouTubeMJ Tube
5:49
Excel Lookup/Search Tip 6 - Vlookup with a Drop Down Menu a…
347.3K viewsNov 6, 2009
YouTubeTeachExcel
1:06
Select cells in Excel
214.5K viewsOct 16, 2019
YouTubeMicrosoft 365
3 Ways to Display (Multiple Items) Filter Criteria in a Pivot Table - Ex…
Feb 21, 2017
excelcampus.com
7:00
Selecting Values with a Form Control Listbox on an Excel Work…
27.8K viewsApr 29, 2016
YouTubeDr. Todd Grande
How to make dependent dropdown lists in Excel
Nov 22, 2022
exceljet.net
1:52
How to use the CHOOSE function in Excel
33.3K viewsNov 9, 2018
YouTubeTechOnTheNet
12:07
Choose and Match Function With Drop Down List - Make Your Own …
27.3K viewsJun 13, 2018
YouTubeThe Organic Chemistry Tutor
4:35
12 Ways to Select Cells in Excel
16.9K viewsDec 10, 2020
YouTubeExcel 10 tutorial
5:53
Excel 2016 - Selecting a Range - How to Highlight Find and Select …
89K viewsOct 3, 2017
YouTubeProfessor Adam Morgan
1:09
How to Quickly Select Data in a Microsoft Excel Table
69K viewsApr 19, 2013
YouTubeJ Burke
0:18
Excel Quick Tip #4 - The Quickest Way to Select a Table - Wise Owl
15.3K viewsDec 2, 2011
YouTubeWiseOwlTutorials
8:18
Select Multiple Columns from Table with Excel Formula. 6 Examples. E…
44.1K viewsApr 23, 2020
YouTubeexcelisfun
6:34
7 Keyboard Shortcuts For Quickly Selecting Cells And Ranges In Excel
507K viewsAug 22, 2018
YouTubeExcel Campus - Jon
4:56
How To Select Excel Cells With Different Formulas Or Values
53.2K viewsOct 31, 2019
YouTubeExcel Campus - Jon
1:49
How to select the highest or lowest value in excel using function
157.2K viewsJan 8, 2019
YouTubeExcel 10 tutorial
See more videos
Static thumbnail place holder