Excel ISREF Function

The Excel ISREF returns TRUE when a cell contains a reference and FALSE if not. You can use the ISREF function to check for a reference in a formula.
- value - The value to check.
The ISREF function returns TRUE to test for a reference in a formula. The ISREF function takes one argument, value, to test. If value is a valid cell reference, range, or named range, ISREF returns TRUE. If value is not a reference, ISREF returns FALSE. ISREF does not evaluate the contents of a reference, just the reference itself.
Examples
ISREF returns TRUE when value is a reference and FALSE if not:
Some functions, like INDEX and OFFSET, can return a reference. As long as the reference is valid, ISREF returns TRUE:
To evaluate a reference as text (i.e. "A1"), use the INDIRECT function:
Notes
- Use the INDIRECT function with ISREF to evaluate a reference as text.
Download 100+ Important Excel Functions
Get over 100 Excel Functions you should know in one handy PDF.