Quick Navigation
ISREF Function
Summary
The ISREF function determines whether a given value is a valid cell reference in Excel. It returns TRUE for valid references like A1 or B10, and FALSE for non-references such as numbers, text, or invalid addresses.
Syntax
ISREF(value)Parameters
| Parameter | Type | Required | Description |
|---|---|---|---|
| value | Any |
Yes | Value to check if it represents a valid reference (cell, range, named range, or table reference) |
Using the ISREF Function
ISREF is valuable when building dynamic formulas that depend on reference validity. Use it to check INDIRECT inputs, validate user-defined names, or create safer dynamic range formulas that adapt based on actual reference existence.
Common ISREF Examples
Basic Reference Check
=ISREF(A1)Returns TRUE if A1 is a valid cell reference (always true for existing cells) TRUE
Invalid Reference Test
=ISREF("XYZ123")Returns FALSE for text that looks like a reference but isn't valid FALSE
Named Range Validation
=ISREF(MyTable)Returns TRUE if MyTable is a defined name or table TRUE
Dynamic INDIRECT Safety
=IF(ISREF(INDIRECT("A"&ROW())),INDIRECT("A"&ROW()),"Invalid")Safely uses INDIRECT only with valid references
Frequently Asked Questions
Common Errors and Solutions
#VALUE! error
Cause: No error - ISREF never returns #VALUE!
Solution: ISREF is error-free for all inputs
Always FALSE for values
Cause: Numbers, text, and logical values aren't references
Solution: Only actual references return TRUE
Notes
- ISREF distinguishes between reference values and literal values
- Works with defined names, table references, and external references
- Doesn't check if referenced cell contains data - only reference validity
- Useful in array formulas and dynamic named range creation
Compatibility
Available in: Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel 2021, Microsoft 365
Not available in:
Content last reviewed: December 9, 2025
Update frequency: As needed
Excel versions tested: Excel 2007+