Syntax
ISREF(value)
| Parameter | Description |
|---|---|
| value | Parameter of the ISREF function. |
Examples
Validate INDIRECT reference
Formula
=ISREF(INDIRECT(A1))
If A1 contains "B5", returns TRUE (valid reference). If A1 contains "XYZ123", returns FALSE (not a valid cell address).
Check named range exists
Formula
=ISREF(SalesData)
Returns TRUE if a named range called SalesData is defined. Returns #NAME? if the name doesn't exist at all (since the parser can't resolve it).
Safe dynamic reference
Formula
=IF(ISREF(INDIRECT("Sheet2!A1")), INDIRECT("Sheet2!A1"), "Sheet not found")
Checks if Sheet2 exists before trying to pull data from it. Returns "Sheet not found" if the reference is invalid.
Common Errors
#NAME?
If you test a named range that doesn't exist (=ISREF(UndefinedName)), the formula errors because the name can't be parsed before ISREF runs.
Tips
Use with INDIRECT
ISREF is most valuable when validating INDIRECT results. INDIRECT returns #REF! for invalid text references — wrap in ISREF to catch that cleanly.
Cannot test undefined names
ISREF can confirm a defined name points to a valid reference, but if the name isn't defined at all, you get #NAME? before ISREF executes.
Rarely needed in practice
Most formulas don't need ISREF. It's mainly useful in dynamic/template spreadsheets where cell references are constructed from user input.
Try ISREF in Viztab
Import your data and use ISREF with 370+ other formulas. No signup required.
Open Viztab