Index Array Excel - 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.

Microsoft Excel Excel Tips and Tricks

AI in the flow of human ambition | Highlights from Microsoft Ignite 2025

AI in the flow of human ambition | Highlights from Microsoft Ignite 2025

YouTubeMicrosoft Events

218.2K views2 weeks ago

@Microsoft 365 getting us through the day, everyday! Helping us stay on track, organized, and helping to bring our visions to life and best of all, you can get Microsoft 365 Premium for 50% off now! #Microsoft365Partner

@Microsoft 365 getting us through the day, everyday! Helping us stay on track, organized, and helping to bring our visions to life and best of all, you can get Microsoft 365 Premium for 50% off now! #Microsoft365Partner

TikTokacquiredstyle

207.4K views6 days ago

Satya Nadella completes the Microsoft 365 Copilot Challenge

Satya Nadella completes the Microsoft 365 Copilot Challenge

YouTubeMicrosoft

25.1K views3 weeks ago

Top videos

INDEX Function

INDEX function - Microsoft Support

INDEX function - Microsoft Support

How to Create an Index in Excel

How to Create an Index in Excel

151.1K views10 months ago

Microsoft Excel Excel Formulas

Top Excel Formulas and Functions

Top Excel Formulas and Functions

YouTubeSimon Sez IT

147.7K viewsJan 17, 2024

Excel Formulas and Functions Tutorial

Excel Formulas and Functions Tutorial

YouTubeKevin Stratvert

4M viewsJul 13, 2019

30 Advanced Excel Formulas and Functions You Need To Know | Most Useful Excel Formulas

30 Advanced Excel Formulas and Functions You Need To Know | Most Useful Excel Formulas

YouTubeDeepak EduWorld

288.8K viewsJul 24, 2024

INDEX Function

INDEX Function

INDEX function - Microsoft Support

INDEX function - Microsoft Support

How to Create an Index in Excel

How to Create an Index in Excel

151.1K views10 months ago

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

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

30.2K viewsJun 6, 2019

YouTubePresentation Process

INDEX with variable array

INDEX with variable array

Index and match on multiple columns

Index and match on multiple columns

Two-way lookup with INDEX and MATCH

Two-way lookup with INDEX and MATCH

How to use the INDEX function in Excel

584K viewsOct 16, 2018

YouTubeTechOnTheNet

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

1.2K viewsMay 16, 2024

YouTubeCoefficient

How to Use the INDEX Function in Excel - Tutorial

13K viewsFeb 18, 2019

YouTubeExcel Tutorials by Y. Acosta

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

2.9K viewsSep 20, 2021

YouTubeSpreadsheeto

Excel Tutorial: How to Use INDEX and MATCH Functions for Data Re…

8K viewsJun 22, 2023

Index Match Formula

corporatefinanceinstitute.com

How to use INDEX and MATCH

How to Use Index Function in Excel

1.3K viewsMay 23, 2022

YouTubeExcel 10 tutorial

INDEX Function explained with Example in Excel

615 viewsAug 17, 2020

YouTubeThe Akshay

How the INDEX function with an array formula works in Excel

394 viewsMar 15, 2023

YouTubeWaqas Learning Hub

Dynamic array formulas in Excel

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

10K viewsDec 1, 2020

YouTubeExcel in a Minute

INDEX Function in Excel - Complete Guide | 5 Examples

19.4K viewsJan 18, 2022

YouTubeComputergaga

INDEX Formula in Excel - Explained with Examples

68.6K viewsApr 13, 2014

YouTubeTrumpExcel

Look Up Values with INDEX and MATCH functions in Microsoft Excel

271.5K viewsNov 22, 2022

YouTubeTeacher's Tech

VBA Search for (Find) Value in Array

automateexcel.com

Excel Index Match Function Tutorial (with 3 examples)

1.1K viewsJul 23, 2023

YouTubeDr. Saeed Faal

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

14.4K viewsNov 29, 2019

YouTubedptutorials

Create Custom Arrays Using INDEX in Excel

664 viewsOct 2, 2020

YouTubeExcelSmith

How to Use INDEX MATCH with Multiple Criteria in Excel (3 Easy S…

124.9K viewsJan 31, 2024

YouTubeSpreadsheeto

How to use Index and Match in Excel

6.8K viewsMar 22, 2021

YouTubeMike's Office

Excel Index & Match and Sumproduct Formulas to Solve a…

4.8K viewsFeb 5, 2021

YouTubeLineth Dela Cruz

See more videos