Information
ISREF Function in Excel
Returns TRUE if the value is a reference.
Syntax
- =ISREF(value)
Arguments
- value (required): Value to test
Examples
- =ISREF(A1) - Test cell reference - Result: TRUE
- =ISREF("A1") - Test text - Result: FALSE
Defensive formulas with ISREF
- Use IS* functions inside IF to branch on blank, error, text, or number cells.
- Prefer [IFERROR](/functions/iferror/) when you only need a fallback display value.
- Error hub: [Fix formula errors](/guides/fix-excel-formula-errors/).
Common errors
- Text cell addresses return FALSE
Use cases
- Formula validation
- Dynamic references
- Error checking
Frequently asked questions
- What is ISREF used for in Excel? ISREF tests if a value is a valid cell reference, returning TRUE or FALSE. It's useful for validating INDIRECT results, checking if named ranges exist, and error-proofing formulas that use dynamic references.
- How do I check if a named range exists? Use =ISREF(INDIRECT("RangeName")). If the named range exists, INDIRECT returns a reference and ISREF returns TRUE. If not, INDIRECT returns #REF! error, but ISREF catches it and returns FALSE.
- Why does ISREF return FALSE for text like 'A1'? Text 'A1' is just a string, not a reference. Use INDIRECT to convert: ISREF(INDIRECT("A1")) returns TRUE. ISREF distinguishes between actual references (A1) and text that looks like references ("A1").
Editorial review
- Reviewed by Excel.Directory Editorial Team. Updated May 2026.