ISREF Function

Checks whether a value is a cell reference.

Category

Information

Available in

All versions, Microsoft 365

Returns

TRUE or FALSE

Want to practice ISREF in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox

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

=ISREF(value) Explain

Arguments

ArgumentRequired?What it does
valueYesThe 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.

B2fx=ISREF(C2)
AB
1ArgumentISREF
2C2 (an empty cell)TRUE
3C2:E9TRUE
4"C2" (text)FALSE
542FALSE

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.

=IF(ISREF(INDIRECT("'"&B1&"'!A1")),"Sheet found","No sheet called "&B1) Explain

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

Kyle Stott

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.