Summary
ISREF returns TRUE when a value is a valid reference. It returns FALSE when the value is not a reference.
This sounds simple, but the distinction matters. A real reference like A1 returns TRUE. A text string like "A1" returns FALSE, because it only looks like a reference.
Purpose
Returns TRUE only when the argument is a valid cell or range reference.
Return Value
TRUE means the argument is a reference. FALSE means it is not.
Syntax
=ISREF(value)You can test a direct reference, a range, or the result of a reference-returning function.
Arguments
- value - [required] The value or expression you want to test as a reference.
ISREF vs Other Functions
| Function | Main job | Useful distinction |
|---|---|---|
ISREF |
Checks whether something is a reference | A1 returns TRUE, but "A1" returns FALSE. |
INDIRECT |
Builds a reference from text | Useful when you want to turn a text address into a live reference first. |
ISTEXT |
Checks for text | Helpful when a value looks like an address but is really just text. |
TYPE |
Returns a type code for the value result | Useful when you care about value type rather than reference status. |
Using ISREF
This function is most useful in formulas that build or pass references around. If you use INDIRECT, OFFSET, or named references, ISREF can help confirm that the result is actually a usable reference.
The key rule is that text does not count as a reference by itself. A string like "Sheet1!A1" only becomes a reference when another function turns it into one.
Example 1 - Check a direct cell reference
A real cell reference returns TRUE.
=ISREF(A1)Check whether A1 is a valid reference. Formula: =ISREF(A1).
Example 2 - Check a text address
A text value that looks like a reference still returns FALSE.
=ISREF("A1") // Returns FALSE.Check whether the text "A1" is itself a reference. Formula: =ISREF("A1").
Example 3 - Test an INDIRECT result
Once text is converted into a real reference, ISREF returns TRUE.
=ISREF(INDIRECT("A1"))Check whether INDIRECT("A1") returns a valid reference. Formula: =ISREF(INDIRECT("A1")).
Example 4 - Test a range
Ranges count as references too.
=ISREF(A1:B10)Check whether A1:B10 is a valid reference. Formula: =ISREF(A1:B10).
Conclusion Recap
- Main job:
ISREFchecks whether an argument is a valid reference. - Important nuance: Text that looks like an address is still just text.
- Useful pair: Combine it with
INDIRECTwhen references are built from text. - Works with: Single cells and ranges.
Tell your friends about this post