ISREF in Google Sheets: References Versus Address Text

• Introduced: first introduction date is not established by the official history reviewed; no desktop release number is inferred.
• Availability: documented in the rolling Google Sheets service; these examples use the web worksheet workflow.
• Checked: October 14, 2026; official ISREF reference. Documentation and independent models, with no native Google Sheets execution or wider client certification.

=ISREF(value)

The required value is tested as a reference. The result does not certify that the referenced cell contains a number, is populated, has no error or is the intended business input. Reference identity and cell content need separate checks.

Create these A2:A5 controls, then fill the two formulas in adjacent columns.

Use =ISREF(A2) in B2 and =ISNUMBER(A2) in C2, filled down. All four cell addresses remain references. Only A2 supplies a numeric value under the numeric-type test.

Compare =ISREF(27), which is FALSE: that expression supplies a number directly rather than its cell reference. Likewise, =ISREF("A2") remains FALSE even though A2 exists.

Put ="A2" in E2. Compare these three expressions:

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

Expected results are TRUE, TRUE and FALSE. The first receives the reference E2; the second inspects E2’s text content; the third receives a text literal. There is no contradiction in a valid referenced cell containing text.

This distinction often matters when a report stores addresses in a column. Testing the address-label cell as a reference does not validate the text inside it as an intended target address.

Google’s INDIRECT reference documents conversion of address text into a cell reference. With A2 still numeric 27:

=ISREF(INDIRECT("A2"))
=INDIRECT("A2")

Expected outputs are TRUE and 27. The first tests the reference constructed by INDIRECT; the second displays the content reached through it. Unlike the quoted address alone, this expression contains a documented reference-generating operation.

With E2 containing the address text A2, =ISREF(INDIRECT(E2)) is also expected TRUE. Changing E2 to the text A3 still produces a reference, but the target now contains text 27 rather than number 27. Use =ISNUMBER(INDIRECT(E2)) when numeric content is the actual requirement; for target A3 that check is FALSE.

Put the integer 2 in H2. In H3 use ="A"&H2, which produces the text A2. Then compare:

=ISREF("A"&H2)
=ISREF(INDIRECT("A"&H2))

Expected results are FALSE and TRUE. Change H2 to 3 and the string becomes A3; the same reference distinction remains. A separate =INDIRECT("A"&H2) retrieves the value from the chosen row.

The explicit construction makes the intended conversion visible, but it is not permission to accept every arbitrary user-supplied string. This guide has not certified invalid-address, deleted-cell, external-file or every named-range case. Do not assume ISREF catches all errors thrown by a nested reference-producing expression.

For the controlled targets A2 and A3, the report can maintain two helper checks: whether the expression constructs a reference, and whether the referenced content is numeric. The results are TRUE/TRUE for A2 and TRUE/FALSE for A3.

That two-column audit prevents a successful reference check from being presented as proof of data quality. A valid reference can also point at the wrong row entirely; verifying the intended address is a separate part of the review.

Use ISTEXT for address labels, ISNUMBER for numeric contents and INDIRECT for deliberate text-to-reference conversion. This guide does not transfer Excel INDEX reference-form behavior into Sheets merely because both products have an INDEX function.

• Google ISREF reference.
• Editorial testing standards.

Examples use fictional inputs, English function names and comma argument separators. Expected outputs are independently modeled from the cited rules, not native Sheets captures. Check the spreadsheet locale when reproducing punctuation-sensitive formulas.