Lookup and reference functions

HLookup

Looks up a value in the first row of a table and returns the corresponding value from another row
Example: HLookup(2, "A1:B2", 1)

Lookup

Looks up a value in the first vector corresponding value from the second vector.
Example: Lookup(2, "A1:A5", "B1:B5")
Looks up a value in the supplied range.
Example: Lookup(2, "A1:B5")

Match

Finds the relative position of a value in the supplied range.
Example: Match(2, "A1:A5", 1)

Row

Returns the row number of the current cell or the supplied range.
Example: Row("A4")

VLookup

Looks up a value in the first column of a table and returns the corresponding value from another column
Example: VLookup(2, "A1:B2", 1)

---

Home