Welcome! Lets start your excel journey..

Welcome! Register Now to Unlock Exclusive Excel Tutorials

Get Started
  • Exclusive Playlists
  • Downloadable Videos
  • No Ads!
  • Exclusive Templates

How to use INDIRECT Function in Excel? Step-By-Step Guide

Admin
Duration: 14:57
Submitted: 3 months ago
Views: 160

Comments (0)

Link to this video:

Description: If you work with formulas in Excel, then you will want to learn how to use the INDIRECT function. This function is very handy for converting text strings into valid references. You can use it to insert labels or other information into your formulas without having to type them out directly. In this video tutorial, we will show you how to use the INDIRECT function in Excel and give you some tips on how to make it work for you! Table Of Content 00:00 Introduction 01:20 INDIRECT Basics - Cell & Range Reference 07:30 INDIRECT Function - Named Ranges Reference 11:43 INDIRECT Function - Worksheet Reference 14:40 Conclusion First thing first lets learn the syntax of INDIRECT Function; =INDIRECT("text string") In the function, "text string" is the text that you want to convert into a valid reference. The INDIRECT function can be used in a number of different ways, but we will focus on three specific examples: cell references, named ranges, and worksheet references. Cell References Using Indirect Function in Excel; Suppose you have a list of data in cells A11:A15 and you want to create a formula that will sum the values in those cells. Rather than typing out the cell references, you can use the INDIRECT function to convert the text string "A11:A15" into a valid reference. The formula would look like this: =SUM(INDIRECT("A11:A15")) This will sum the values in cells A11 through A15. You can also use the INDIRECT function to convert text strings into range references. For example, if you want to sum the values in cells B12:B17, you could use this formula: =SUM(INDIRECT("B12:B17")) This will sum the values in cells B12 through B17. Named Ranges Using Indirect Function in Excel; You can also use the INDIRECT function to create named ranges. Suppose you have a range of data in cells A11:A15 and you want to create a named range called "SumOfA11-A15". You can use the INDIRECT function to do this. The formula would look like this: =INDIRECT("SumOf"&A11&"-A15") This will create a named range called "SumOfA11-A15" that contains the data in cells A11 through A15. Worksheet References Using Indirect Function in Excel; You can also use the INDIRECT function to create worksheet references. For example, if you want to refer to a cell on another sheet, you can use the INDIRECT function to do this. The formula would look like this: =INDIRECT("sheet name"&A11) This will refer to the cell A11 on the sheet named "sheet name". Now that you know how to use the INDIRECT function, here are some tips for making it work for you: - When using the INDIRECT function, be sure to enclose the text string in quotation marks. - You can use the & operator to create text strings so you don't have to type out long references. - The INDIRECT function can be used in a number of different ways, so experiment with it and see how you can best use it to suit your needs. That's all for now! Be sure to check out our other Excel tutorials and videos!