A "lookup" field in Benchling works in the same method as a "lookup" feature in Excel. The "lookup" field searches for a one-row or one-column range (known as a vector) for a value and returns a value from the same position in a second one-row or one-column range.

#### Syntax:

**=LOOKUP(lookup_value, lookup_vector, [result_vector])**

For example, in the following table, the function **LOOKUP(3,A1:A5,B1:B5) **should return the value *Cell 3.*