Lookup and reference functions

Address

Returns a cell reference as a string. Does not support the R1C1 format.
Example: Address(0, 0, 4, "Worksheet")

Choose

Returns the value from a list, corresponding to the given 1-based index..
Example: Choose(1, "Value1", "Value2")

Column

Returns the columnnumber of the current cell or the supplied range.
Example: Column("B4")

Columns

Returns the number of columns in the supplied range.
Example: Columns("B4:E10")

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")

Rows

Returns the number of rows in the supplied range.
Example: Rows("A4:C10")

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