Index Formulas Functions - Search Videos

Return array with INDEX function

Return array with INDEX function

To get INDEX to return an array of items to another function, you can use an obscure trick based on the IF and N functions. In the example shown, the formula in E5 is: =SUM(INDEX(data,N(IF(1,{1,2,3})))) where "data" is the named range B5:B10. In Excel 2021 and later, this trick is not necessary, thanks to dynamic arrays. See the TAKE function.

Excel Index Match

The ULTIMATE Index Match Tutorial (5 Real-World Examples)

The ULTIMATE Index Match Tutorial (5 Real-World Examples)

YouTubeKenji Explains

342.6K viewsJul 23, 2023

4 Mins. to MASTER Excel INDEX & MATCH formulas!

4 Mins. to MASTER Excel INDEX & MATCH formulas!

YouTubeMyOnlineTrainingHub

482.6K viewsApr 13, 2023

How to use Excel Index Match (the right way)

How to use Excel Index Match (the right way)

YouTubeLeila Gharani

3.9M viewsMar 4, 2017

Top videos

INDEX Function

101 Advanced Excel Formulas & Functions Examples

101 Advanced Excel Formulas & Functions Examples

myexcelonline.com

127K viewsMar 3, 2021

Dynamic array formulas in Excel

Dynamic array formulas in Excel

Excel Vlookup Function

How to use the VLOOKUP function in Excel

How to use the VLOOKUP function in Excel

YouTubeTechOnTheNet

5M viewsSep 28, 2018

VLOOKUP in Excel | Step-by-Step Tutorial for Beginners

VLOOKUP in Excel | Step-by-Step Tutorial for Beginners

YouTubeKevin Stratvert

1.9M viewsOct 2, 2024

Excel Vlookup Tutorial - Everything You Need To Know

Excel Vlookup Tutorial - Everything You Need To Know

YouTubeExcel Campus - Jon

2.8M viewsAug 15, 2019

INDEX Function

INDEX Function

101 Advanced Excel Formulas & Functions Examples

101 Advanced Excel Formulas & Functions Examples

127K viewsMar 3, 2021

myexcelonline.com

Dynamic array formulas in Excel

Dynamic array formulas in Excel

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

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

How to Use INDEX MATCH With Multiple Criteria in Excel

How to Use INDEX MATCH With Multiple Criteria in Excel

spreadsheeto.com

Excel INDEX Function | Formula Examples FREE Video

Excel INDEX Function | Formula Examples FREE Video

How to use INDEX and MATCH

How to use INDEX and MATCH

What Is an Index? Examples, How It's Used, and How to Invest

investopedia.com

Index Match Formula

corporatefinanceinstitute.com

Index Number | Definition, Types & Formula

117K viewsDec 13, 2014

Study.comYuanxin (Amy) Yang Alcocer

How to use the FIND function in Excel

301.1K viewsMay 12, 2019

YouTubeTechOnTheNet

10 Advanced Excel Formula Examples | FREE Excel Course

193.8K viewsMay 8, 2019

YouTubeTrumpExcel

How to use Formulas and Functions in Microsoft Excel

462.1K viewsApr 19, 2021

YouTubeTeacher's Tech

MS Excel - Index Function

943.5K viewsJan 15, 2018

YouTubeTutorialsPoint

How to Use the NEW & IMPROVED Excel XLOOKUP (with 5 Examples)

3.9M viewsNov 28, 2019

YouTubeLeila Gharani

INDEX MATCH Excel Tutorial

544.4K viewsJul 14, 2021

YouTubeKevin Stratvert

Excel: INDEX and MATCH

252.7K viewsFeb 8, 2021

YouTubeTechnology for Teachers and Students

Excel Index Match Tutorial

1.2M viewsNov 4, 2017

YouTubeTEKNISHA

The Maths Prof: The Rules of Indices / Exponents (part 1)

330.3K viewsMay 31, 2017

YouTubeThe Maths Prof

Index Notation Made Easy!

10.5K viewsMar 7, 2019

YouTubeMaths Made Easy

Excel Array Formulas Explained with MIN and IF Functions (Part 1 …

192.1K viewsMar 23, 2018

YouTubeExcel Campus - Jon

Excel Index Funktion | =INDEX() ✅ Tutorial

19.5K viewsFeb 17, 2015

YouTubeTechnikShavo

How to use the INDEX function in Excel

585.5K viewsOct 16, 2018

YouTubeTechOnTheNet

INDEX Formula in Excel - Explained with Examples

68.7K viewsApr 13, 2014

YouTubeTrumpExcel

How to add an index column in Microsoft Excel

63.6K viewsOct 2, 2019

YouTubeMicrosoft 365

How to Use the INDEX Function in Excel - Tutorial

13K viewsFeb 18, 2019

YouTubeExcel Tutorials by Y. Acosta

How to Use VLOOKUP and INDEX MATCH in Excel

94.3K viewsOct 26, 2017

YouTubeVertex42

Excel INDEX / MATCH Function for an Advanced Lookup

94.9K viewsOct 9, 2017

YouTubeComputergaga

Creating an Index Number series in Excel

25.5K viewsMar 11, 2018

YouTubeMy Data Analysis Site

See more videos