DATAENTRY

Description: Returns the value from the specified cell in the selected data source. Use numbers to identify both the row and column (e.g., for cell A2 in the data sheet, enter 2 for the row and 1 for the column).

Syntax: DATAENTRY(Data_Src, Row, Column)

Data_Src is the source data sheet from which the value is taken.

Row is the row number in the data sheet.
Column is the column number in the data sheet.

Remarks:

The Data_Src can be one of the following values:

If using a default data source, it must be either 1, 2, 3 or 4, as selected from the Data Source Index drop-down list.
It can take a data sheet name (e.g., "Folio1!Data 1").
It can take a variable name defined in the Defined Names window (e.g., datasource).

The Row and Column values must be greater than 0.

Example:

DATAENTRY("Folio1!Data 1", 1, 2) = F

Note that this value will vary depending on the source data set.