lookup

Subtopics

lookup(one key column)

lookup(one key column), given a key column, constructs the row source key, looks up the row source entry, and returns the double numeric value of resultColumn from the row source.

lookup(String rowsourceName, String keyColumn1, String resultColumn)

See lookup.

lookup(two key columns)

lookup(two key columns) looks up a row source with two key-columns for the value of resultColumn.

lookup(String rowsourceName, String keyColumn1, String keyColumn2, String resultColumn)

See lookup.

lookup(three key columns)

lookup(three key columns) looks up a row source with three key-columns for the value of resultColumn.

lookup(String rowsourceName, String keyColumn1, String keyColumn2, String keyColumn3, String resultColumn)

See lookup.

lookup(four key columns)

lookup(four key columns) looks up a row source with four key-columns for the value of resultColumn

lookup(String rowsourceName, String keyColumn1, String keyColumn2, String keyColumn3, String keyColumn4, String resultColumn)