Excel Index - Search Videos

Two-way lookup with INDEX and MATCH

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.

Related Products

Excel Templates

Excel Cell at Index

Index Page Template Excel

#Excel Index Function

Return array with INDEX function

Return array with INDEX function

exceljet.netMay 14, 2024

INDEX function

MicrosoftMay 20, 2014

Top videos

INDEX & MATCH Functions Combo in Excel (10 Easy Examples)

INDEX & MATCH Functions Combo in Excel (10 Easy Examples)

INDEX Function

How to use INDEX and MATCH

How to use INDEX and MATCH

Excel Index Match

Excel formula: INDEX and MATCH with multiple criteria - Excelchat

Excel formula: INDEX and MATCH with multiple criteria - Excelchat

How to use INDEX and MATCH with a table

How to use INDEX and MATCH with a table

How to Use INDEX MATCH With Multiple Criteria in Excel

How to Use INDEX MATCH With Multiple Criteria in Excel

spreadsheeto.com

INDEX & MATCH Functions Combo in Excel (10 Easy Examples)

INDEX & MATCH Functions Combo in Excel (10 Easy Examples)

INDEX Function

INDEX Function

How to use INDEX and MATCH

How to use INDEX and MATCH

Excel formula: INDEX and MATCH with multiple criteria - Excelchat

Excel formula: INDEX and MATCH with multiple criteria - Excelchat

Index Match Formula

Index Match Formula

corporatefinanceinstitute.com

INDEX Formula in Excel - Explained with Examples

INDEX Formula in Excel - Explained with Examples

68.8K viewsApr 13, 2014

YouTubeTrumpExcel

How to use the INDEX function in Excel

How to use the INDEX function in Excel

591.9K viewsOct 16, 2018

YouTubeTechOnTheNet

How to use the INDEX function in Excel [step by step]

3.7K viewsSep 20, 2021

YouTubeSpreadsheeto

Lookup in a Table with Row and Column Criteria using INDEX and …

17.8K viewsApr 7, 2023

YouTubeExcel Insights

How to Use the INDEX Function Formula in Excel: The Ultimate Wa…

1.4K viewsMay 16, 2024

YouTubeCoefficient

How to use Index Function in Excel (Array & Reference)

30.2K viewsJun 6, 2019

YouTubePresentation Process

Index and match on multiple columns

Excel for beginners: INDEX and MATCH functions to lookup data fr…

9.6K viewsNov 12, 2020

YouTubeBitesize Excel

INDEX and MATCH with multiple criteria

How to Perform INDEX & MATCH with MULTIPLE Criteria in Excel!

35.6K viewsMar 2, 2024

YouTubeAnser's Excel Academy

How to Use Index Function in Excel

1.3K viewsMay 23, 2022

YouTubeExcel 10 tutorial

How to Use the INDEX Function in Excel - Tutorial

13K viewsFeb 18, 2019

YouTubeExcel Tutorials by Y. Acosta

INDEX and MATCH with multiple criteria || Excel Tips & Tricks || dpt…

14.4K viewsNov 29, 2019

YouTubedptutorials

6 Incredible Excel INDEX/MATCH Lookup Examples - Workbook Incl…

435.7K viewsFeb 28, 2018

YouTubeTeachExcel

How to use Index Match in Excel | How Index Match Works | Comple…

5.1K viewsMar 20, 2020

YouTubeBlue Sun Channel

How to add an index column in Microsoft Excel

63.9K viewsOct 2, 2019

YouTubeMicrosoft 365

Excel INDEX / MATCH Function for an Advanced Lookup

94.9K viewsOct 9, 2017

YouTubeComputergaga

How to use Index and Match in Excel

6.8K viewsMar 22, 2021

YouTubeMike's Office

HOW TO USE THE INDEX Function with Reference Form BY EXCEL I…

10.1K viewsDec 1, 2020

YouTubeExcel in a Minute

Index Match Excel Function Tutorial [With Examples]

960 viewsNov 5, 2019

YouTubeeTrainer Box

Create a Dynamic Named Range using the INDEX Function in Excel

43.9K viewsApr 1, 2017

YouTubeComputergaga

How to Use VLOOKUP and INDEX MATCH in Excel

94.9K viewsOct 26, 2017

YouTubeVertex42

Look Up Values with INDEX and MATCH functions in Microsoft Excel

280.3K viewsNov 22, 2022

YouTubeTeacher's Tech

INDEX MATCH Excel Tutorial

557.4K viewsJul 14, 2021

YouTubeKevin Stratvert

See more videos