Exceljet

Quick, clean, and to the point

Excel ISREF Function

Excel ISREF function
Summary 

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.

Purpose 
Test for a reference
Return value 
A logical value (TRUE or FALSE)
Syntax 
=ISREF (value)
Arguments 
  • value - The value to check.
Version 
Usage notes 

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:

=ISREF(A1) // returns TRUE
=ISREF(A1:C1) // returns TRUE
=ISREF(Sheet1!A1) // returns TRUE
=ISREF("apple") // returns FALSE
=ISREF(100) // returns FALSE
=ISREF(ZZZ1) // returns FALSE

Some functions, like INDEX and OFFSET, can return a reference. As long as the reference is valid, ISREF returns TRUE:

=ISREF(INDEX(A:A,10)) // returns TRUE
=ISREF(OFFSET(A1,1,1)) // returns TRUE

To evaluate a reference as text (i.e. "A1"), use the INDIRECT function:

=ISREF(INDIRECT("A1")) // returns TRUE
=ISREF(INDIRECT("ZZZ1")) // returns FALSE

Notes

Download 100+ Important Excel Functions

Get over 100 Excel Functions you should know in one handy PDF.