ISREF in Excel: Test References Instead of Cell Contents

• Introduced: first introduction version is not established by the official history reviewed; the current product list is not a launch record.
• Availability: official help lists Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel 2024, Excel 2024 for Mac, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2016, Excel Web App.
• Checked: October 14, 2026; official ISREF reference. Documentation and independently modeled examples; no native Excel execution or broader platform certification.

=ISREF(value)

The required argument can be a value, expression or reference. Microsoft defines TRUE as indicating a reference and illustrates the distinction between a valid cell reference and an invalid address. This test is about reference identity, not the quality of whatever is stored in that cell.

Do not interpret TRUE as “the cell contains a valid number,” “the cell is populated,” or “the referenced result has no errors.” Those require different tests.

Create the following controls and place the two tests in adjacent columns.

For example, B2 is =ISREF(A2) and C2 is =ISNUMBER(A2), filled down. All four A addresses are valid references, including the address of the error cell. Only A2 supplies a numeric content value.

Compare the literal controls =ISREF(12) and =ISREF("A2"): both are FALSE because neither argument is a reference. These controls also show why substituting an address string for a worksheet reference changes the meaning of a formula.

Put ="A2" in E2. Then compare:

=ISREF(E2)
=ISTEXT(E2)
=ISREF("A2")

The results are TRUE, TRUE, FALSE, respectively. The first formula receives a reference to E2; the second inspects E2’s text content; the third receives a text literal directly. The two TRUE results are therefore compatible.

If the goal is to interpret address text, an explicit reference-generating function such as INDIRECT is a different operation, with its own syntax, invalid-address and external-workbook restrictions. This guide does not certify arbitrary user-supplied address strings or closed-workbook references through ISREF alone.

Enter the amounts 12, 18, 25 in H2:H4. Excel’s INDEX reference documentation describes returning a reference at the requested position. Use these scalar controls:

=ISREF(INDEX(H2:H4,2,1))
=SUM(INDEX(H2:H4,2,1))

Expected results are TRUE and 18. The first establishes that the selection supplies a reference; the second uses the selected cell’s numeric content.

Now change H3 from 18 to the text ="Pending". The selected reference remains H3, so the ISREF result remains TRUE. The referenced SUM control has expected result 0, because that one-cell reference contains text rather than a number. Restore H3 to 18 for the next example.

With H2:H4 restored to 12, 18, 25, use:

=ISREF(H2:INDEX(H2:H4,2,1))
=SUM(H2:INDEX(H2:H4,2,1))

The range ends at H3. Expected outputs are TRUE and 30. Changing the INDEX position from two to three expands the endpoint to H4; the total becomes 55, while the reference test stays TRUE.

This can make an audit easier to read: one helper checks the generated reference and another checks the selected contents. ISREF does not verify that the chosen endpoint is the business-correct one. A perfectly valid reference can still select the wrong rows.

A real reference to an error-valued cell is different from an expression that fails to produce a reference. These examples avoid promising one universal result for every invalid INDIRECT expression, deleted reference, external link or array context.

Use ISERROR for error-valued contents, ISBLANK for empty-cell checks, and INDEX for documented reference construction. The address-versus-content distinction should be settled before choosing a fallback formula.

• Microsoft ISREF reference.
• Editorial testing standards.

The datasets are fictional. Expected results follow the cited rules and independent arithmetic or type models; they are not native application captures. Examples use English function names and comma argument separators.