# How to use Excel INDIRECT function

## SUMMARY INFO

All the basic information regarding INDIRECT function in Excel is listed in the table below. (This data is regularly updated from Microsoft and several resources)

 Function: INDIRECT Function Category: Lookup and reference Description: Returns a reference indicated by a text value Return Value: A valid worksheet reference. Syntax: =INDIRECT (ref_text, [a1]) Applies to: Excel 2016, Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000 Other languages: English: INDIRECT French:  INDIRECT German:  INDIREKT Spanish: INDIRECTO Dutch: INDIRECT Italian: INDIRETTO Russian: ДВССЫЛ Danish: INDIREKTE Swedish: INDIREKT Portuguese (Brazil): INDIRETO Polish: ADR.POŚR Finnish: EPÄSUORA Norwegian: INDIREKTE Portuguese (Portugal): INDIRECTO Czech: NEPŘÍMÝ.ODKAZ Hungarian: INDIREKT Turkish: DOLAYLI All Other Languages: INDIRECT Related Functions: INDEX, MATCH, VLOOKUP

## FUNCTION DETAILS

Syntax details with an example regarding the correct usage of indirect function in Excel can be seen below.

### =INDIRECT (ref_text, [a1])

ref_text A reference supplied as text.
a1 [optional] A boolean to indicate A1 or R1C1-style reference. Default is TRUE = A1 style.

## VIDEO EXAMPLES

Check the video below to see How to use Excel INDIRECT formula with some examples:

Here we provide a list of useful links which can be useful while trying to learn the function usage with some INDIRECT examples and tips.

Microsoft Office support page – INDIRECT Excel function:
https://support.office.com/en-us/article/INDIRECT-function-474b3a3a-8a26-4f44-b491-92b6306fa261

## EXCEL FORMULAS TRAINER

As said: Practice Makes Perfect!

Test your Excel skills in Excel itself with our unique product: Excel Formulas Trainer.

30 sections and around 100 questions with full hands-on experience. Progress tracking, dashboard, error checking and many more. Check it now: