ISREFEXIST

Verifies whether a reference exists and returns a logical result.

The ISREFEXIST function returns TRUE if the specified reference exists in the sheet. It returns FALSE if the reference is invalid or does not exist. It is commonly used to validate references before applying calculations or logic.

Syntax

ISREFEXIST(reference)

Arguments

• reference - The reference to validate.

Return value

Returns TRUE if a valid reference exists; otherwise, returns FALSE.

Example

IF(ISREFEXIST(2026 Revenue Plan), 2026 Revenue Plan, "Reference Does Not Exist")

In this example, the ISREFEXIST function checks whether the 2026 Revenue Plan reference exists. If the condition is TRUE, the formula returns the value of the 2026 Revenue Plan; otherwise, it returns the text 'Reference Does Not Exist'.

Excel equivalent

ISREF