Skip to content
xlsoffice. All Rights Reserved
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Lookup and Reference Examples

  • Count rows with at least n matching values
  • Left Lookup in Excel
  • How to use Excel ROW Function
  • Two-way lookup with VLOOKUP in Excel
  • How to get last column number in range in Excel

Data Analysis Examples

  • Add Outline to Data in Excel
  • Move chart to a separate worksheet in Excel
  • Randomize/ Shuffle List in Excel
  • Get column index in Excel Table
  • How to calculate average last N values in a table in Excel

Data Validation Examples

  • Excel Data validation require unique number
  • Excel Data validation must contain specific text
  • Excel Data validation only dates between
  • Excel Data validation don’t exceed total
  • Excel Data validation unique values only

How to use Excel INDIRECT Function

by

This Excel tutorial explains how to use the INDIRECT function with syntax and examples.

Excel INDIRECT function Description

Microsoft Excel INDIRECT function returns the reference to a cell based on its string representation.

The INDIRECT function is a built-in function in Excel that is categorized as a Lookup/Reference Function that can be entered as part of a formula in a cell of a worksheet.

Worked Example:   Average the last 3 numeric values in Excel

Explanation: Based on the example above, the INDIRECT function would return:

=INDIRECT("$B$4")
Result: 3

=INDIRECT("A5")
Result: 10570

=INDIRECT("A5", TRUE)
Result: 10570

=INDIRECT("R2C3", FALSE)
Result: $3.50

Syntax

The syntax for the INDIRECT function in Microsoft Excel is:

INDIRECT( string_reference, [ref_style] )

Arguments

string_reference
A textual representation of a cell reference.
ref_style
Optional. It is either a TRUE or FALSE value. TRUE indicates that string_reference will be interpreted as an A1-style reference. FALSE indicates that string_reference will be interpreted as an R1C1-style reference. If this parameter is omitted, it will interpret string_reference as an A1-style.
Worked Example:   Sum bottom n values in Excel

Returns

The INDIRECT function returns the reference to a cell and thus displays the referenced cell’s value.

Worked Example:   How to reference named range different sheet in Excel

Post navigation

Previous Post:

How to use Excel OFFSET function

Next Post:

How to use Excel LOOKUP Function

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others
  • How to create email address from name in Excel
  • How to use double quotes inside a formula in Excel
  • DOLLAR function: Description, Usage, Syntax, Examples and Explanation
  • How to Capitalize first letter in a sentence in Excel
  • Excel MAX, MATCH and ADDRESS function illustration
  • Calculate number of hours between two times in Excel
  • Get day name from date in Excel
  • Sum through n months in Excel
  • Get days between dates ignoring years in Excel
  • Sum race time splits in Excel
  • How to calculate annuity for interest rate in excel
  • CUMIPMT function: Description, Usage, Syntax, Examples and Explanation
  • COUPDAYS function: Description, Usage, Syntax, Examples and Explanation
  • DDB function: Description, Usage, Syntax, Examples and Explanation
  • DISC function: Description, Usage, Syntax, Examples and Explanation
Acronyms, Abbreviations, Initialism & What They Stand For
© 2021 xlsoffice. All Rights Reserved | Teal Smiles