🔗 The Text-to-Ref Converter

Goal: Fetch the value from the address written in cell A1.
INDIRECT reads text (e.g., "C3") and turns it into a valid reference.

Ready...

💻 Formula Structure

=INDIRECT(ref_text, [a1])
  • 1. Ref Text: A text string that looks like an address (e.g., "C3").
  • 2. A1: (Optional) True = A1 style, False = R1C1 style.
-- Read address in A1, fetch that value
=INDIRECT( A1 )
Final Value:
-

⚠️ Common Pitfalls

🚫 Volatile Function
INDIRECT recalculates every single time you change ANY cell in the workbook. Use sparingly to avoid slow performance.
🚫 #REF! Error
If the text inside A1 is not a valid address (e.g., "Hello"), Excel cannot find it and returns #REF!.