ISREF Function in Google Sheets

Determine if a value is a cell reference using the ISREF function.

ISREF Function

The ISREF function in Google Sheets is used to check if a value is a valid cell reference.

Syntax

ISREF(value)
  • value: The value or expression you want to test. This is a required parameter.

Example

  1. Cell Reference Check

Check if a value is a cell reference:

=ISREF(A1)

This will return TRUE if A1 is a reference.

Notes

  • Returns TRUE only for valid cell references.
  • Useful for verifying dynamic references in formulas.
  • INDIRECT: Convert a text string into a valid reference.
  • ADDRESS: Create a cell address from row and column numbers.