GET.DEF

Macro Sheets Only

Returns the name, as text, that is defined for a particular area, value, or formula in a workbook. Use GET.DEF to get the name corresponding to a definition. To get the definition of a name, use GET.NAME.

Syntax

GET.DEF(def_text, document_text, type_num)

Def_text can be anything you can define a name to refer to, including a reference, a value, an object, or a formula.

• References must be given in R1C1 style, such as "R3C5".
• If def_text is a value or formula, it is not necessary to include the equal sign that is displayed in the Refers To box in the Define Name dialog box, which appears when you choose the Name command from the Define submenu on the Insert Menu.
• If there is more than one name for def_text, GET.DEF returns the first name. If no name matches def_text, GET.DEF returns the #NAME? error value.

Document_text specifies the sheet or macro sheet that def_text is on. If document_text is omitted, it is assumed to be the active macro sheet.

Type_num is a number from 1 to 3 specifying which types of names are returned.

Type_num Returns

1 or omitted Normal names only

2 Hidden names only

3 All names

Examples

If the specified range in Sheet4 is named Sales, the following macro formula returns "Sales":

GET.DEF("R2C2:R9C6", "Sheet4")

If the value 100 in Sheet4 is defined as Constant, the following macro formula returns "Constant":

GET.DEF("100", "Sheet4")

If the specified formula in Sheet4 is named SumTotal, the following macro formula returns "SumTotal":

GET.DEF("SUM(R1C1:R10C1)", "Sheet4")

If 3 is defined as the hidden name Counter on the active macro sheet, the following macro formula returns "Counter":

GET.DEF("3", , 2)

Related Functions

GET.CELL Returns information about the specified cell

GET.NAME Returns the definition of a name

GET.NOTE Returns characters from a note

NAMES Returns the names defined on a workbook

List of Information Functions