How do I use INDIRECT in Excel?
Use INDIRECT when you want to turn text into a cell reference. Enter Reference text, Reference style in that order, then add optional arguments when needed.
Excel Function
INDIRECT
Converts text to a cell reference.
INDIRECT(ref_text, [a1])Arguments
ref_text
RequiredEnter a date/reference-related value.
a1
OptionalSet reference style. TRUE/omitted = A1 style, FALSE = R1C1 style.
Practice Preview
Use INDIRECT to return the value referenced by "B2".
Example Table
| # | AProduct ID | BProduct Name | CPrice | DStock |
|---|---|---|---|---|
| 2 | P001 | Apple | 120 | 80 |
| 3 | P002 | Banana | 98 | 120 |
| 4 | P003 | Notebook | 450 | 35 |
| 5 | P004 | Pen | 300 | 60 |
| 6 | P005 | Grapes | 150 | 45 |
| 7 | P006 | Ruler | 250 | 20 |
| 8 | P007 | Peach | 86 | 55 |
How to Use (Formula)
=INDIRECT("B2", TRUE)Result
Apple
Practice This Function
INDIRECT FAQ
Where can I practice INDIRECT?
Use the "Start Function Practice" button to jump straight into INDIRECT drills.
What arguments does INDIRECT use?
The main arguments are Reference text, Reference style. Start with the required ones, then add optional arguments if needed.