Lookup

Syntax:

lookup( Table, Table Column Condition )

The lookup() formula lets you access rows and values from a table to inspect or reuse.

Examples