Menu
EXCEL INDIRECT FUNCTION
Excel INDIRECT Function Introduction
This function converts a valid worksheet reference into a cell reference.
Description of Excel INDIRECT Function
Syntax:
=INDIRECT (ref_text, [a1])
Parameter list:
- ref text – A text-based reference.
- a1 – [optional] a boolean (TRUE or FALSE) indicating if the reference is A1 or R1C1. TRUE = A1 style is the default.
Step By Step Guide of INDIRECT Function
Example :
Key Points
- INDIRECT is used to construct or supply a text-based reference. When you need to transform a text value into a valid cell reference, use indirect.
- Even if cells, rows, or columns are introduced or deleted, the INDIRECT reference will not change.
Related Functions
HLOOKUP Function
HLOOKUP Function
Explore NowVLOOKUP Function
VLOOKUP Function
Explore NowINDEX Function
INDEX Function
Explore NowMATCH Function
MATCH Function
Explore NowDATE Function
DATE Function
Explore NowIF Function
IF Function
Explore NowOR Function
OR Function
Explore NowAND Function
AND Function
Explore NowRANK Function
RANK Function
Explore NowSUMIF Function
SUMIF Function
Explore NowXIRR Function
XIRR Function
Explore NowWORKDAYS Function
WORKDAYS Function
Explore Now
