Excel Function

INDIRECT

Converts text to a cell reference.

INDIRECT(ref_text, [a1])

Arguments

ref_text

Required

Enter a date/reference-related value.

a1

Optional

Set reference style. TRUE/omitted = A1 style, FALSE = R1C1 style.

Practice Preview

return a value from a text-defined reference. Use INDIRECT to Converts text to a cell reference. use "B2" for ref_text, use TRUE for a1. Fill the argument fields below and complete a formula that achieves this goal.

Sample correct formula

=INDIRECT("B2", TRUE)

Practice This Function

Practice in Sequential ModeBack to Function List