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.
up
