ISREF Function
Checks whether a value is a cell reference.
Category
Information
Available in
All versions, Microsoft 365
Returns
TRUE or FALSE
Overview
ISREF returns TRUE when its argument is a reference to a cell or range — like A1, B2:D9 or a range name — and FALSE for plain values.
Its main use is checking that a reference built from text (with INDIRECT) actually points somewhere valid.
Syntax
Arguments
| Argument | Required? | What it does |
|---|---|---|
| value | Yes | The thing to check. It's what you type — not what's in the cell — that matters. |
Examples
Example 1 — Reference or not?
A reference counts even if the cell is empty; text that merely looks like an address does not.
| A | B | |
|---|---|---|
| 1 | Argument | ISREF |
| 2 | C2 (an empty cell) | TRUE |
| 3 | C2:E9 | TRUE |
| 4 | "C2" (text) | FALSE |
| 5 | 42 | FALSE |
Example 2 — Does that sheet name exist?
Managers type a sheet name in B1. INDIRECT returns #REF! for a name that doesn't exist, so ISREF is FALSE.
The apostrophes around the name let it contain spaces, such as 'Q1 Sales'.
Common mistakes
- Checking what's inside the cell. ISREF looks at the argument you wrote, not the cell's contents. =ISREF(A1) is TRUE even if A1 holds the text "hello".
Notes

Author
Kyle Stott
Certified Microsoft Excel Expert
Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.