# LookupRef

class
**LookupRef** (View source)

## Methods

CELL_ADDRESS.

COLUMN.

COLUMNS.

ROW.

ROWS.

CHOOSE.

MATCH.

INDEX.

TRANSPOSE.

VLOOKUP The VLOOKUP function searches for value in the left-most column of lookup_array and returns the value in the same row based on the index_number.

HLOOKUP The HLOOKUP function searches for value in the top-most row of lookup_array and returns the value in the same column based on the index_number.

LOOKUP The LOOKUP function searches for value either from a one-row or one-column range or from an array.

## Details

###
at line 34
```
static string
```**cellAddress**(mixed $row, mixed $column, int $relativity = 1, bool $referenceStyle = true, string $sheetText = '')

**cellAddress**(mixed $row, mixed $column, int $relativity = 1, bool $referenceStyle = true, string $sheetText = '')

CELL_ADDRESS.

Creates a cell address as text, given specified row and column numbers.

Excel Function: =ADDRESS(row, column, [relativity], [referenceStyle], [sheetText])

###
at line 88
```
static int|int[]
```**COLUMN**(null|array|string $cellAddress = null)

**COLUMN**(null|array|string $cellAddress = null)

COLUMN.

Returns the column number of the given cell reference If the cell reference is a range of cells, COLUMN returns the column numbers of each column in the reference as a horizontal array. If cell reference is omitted, and the function is being called through the calculation engine, then it is assumed to be the reference of the cell in which the COLUMN function appears; otherwise this function returns 0.

Excel Function: =COLUMN([cellAddress])

###
at line 131
```
static int
```**COLUMNS**(null|array|string $cellAddress = null)

**COLUMNS**(null|array|string $cellAddress = null)

COLUMNS.

Returns the number of columns in an array or reference.

Excel Function: =COLUMNS(cellAddress)

###
at line 165
```
static int
```**ROW**(null|array|string $cellAddress = null)

**ROW**(null|array|string $cellAddress = null)

ROW.

Returns the row number of the given cell reference If the cell reference is a range of cells, ROW returns the row numbers of each row in the reference as a vertical array. If cell reference is omitted, and the function is being called through the calculation engine, then it is assumed to be the reference of the cell in which the ROW function appears; otherwise this function returns 0.

Excel Function: =ROW([cellAddress])

###
at line 208
```
static int
```**ROWS**(null|array|string $cellAddress = null)

**ROWS**(null|array|string $cellAddress = null)

ROWS.

Returns the number of rows in an array or reference.

Excel Function: =ROWS(cellAddress)

###
at line 241
```
static mixed
```**HYPERLINK**(string $linkURL = '', string $displayName = null, Cell $pCell = null)

**HYPERLINK**(string $linkURL = '', string $displayName = null, Cell $pCell = null)

HYPERLINK.

Excel Function: =HYPERLINK(linkURL,displayName)

###
at line 278
```
static mixed
```**INDIRECT**(null|array|string $cellAddress = null, Cell $pCell = null)

**INDIRECT**(null|array|string $cellAddress = null, Cell $pCell = null)

INDIRECT.

Returns the reference specified by a text string. References are immediately evaluated to display their contents.

Excel Function: =INDIRECT(cellAddress)

NOTE - INDIRECT() does not yet support the optional a1 parameter introduced in Excel 2010

###
at line 346
```
static string
```**OFFSET**(null|string $cellAddress = null, mixed $rows = 0, mixed $columns = 0, mixed $height = null, mixed $width = null, Cell $pCell = null)

**OFFSET**(null|string $cellAddress = null, mixed $rows = 0, mixed $columns = 0, mixed $height = null, mixed $width = null, Cell $pCell = null)

OFFSET.

Returns a reference to a range that is a specified number of rows and columns from a cell or range of cells. The reference that is returned can be a single cell or a range of cells. You can specify the number of rows and the number of columns to be returned.

Excel Function: =OFFSET(cellAddress, rows, cols, [height], [width])

###
at line 432
```
static mixed
```**CHOOSE**(...$chooseArgs)

**CHOOSE**(...$chooseArgs)

CHOOSE.

Uses lookup_value to return a value from the list of value arguments. Use CHOOSE to select one of up to 254 values based on the lookup_value.

Excel Function: =CHOOSE(index_num, value1, [value2], ...)

###
at line 471
```
static int
```**MATCH**(mixed $lookupValue, mixed $lookupArray, mixed $matchType = 1)

**MATCH**(mixed $lookupValue, mixed $lookupArray, mixed $matchType = 1)

MATCH.

The MATCH function searches for a specified item in a range of cells

Excel Function: =MATCH(lookup_value, lookup_array, [match_type])

###
at line 588
```
static mixed
```**INDEX**(mixed $arrayValues, mixed $rowNum = 0, mixed $columnNum = 0)

**INDEX**(mixed $arrayValues, mixed $rowNum = 0, mixed $columnNum = 0)

INDEX.

Uses an index to choose a value from a reference or array

Excel Function: =INDEX(range_array, row_num, [column_num])

###
at line 646
```
static array
```**TRANSPOSE**(array $matrixData)

**TRANSPOSE**(array $matrixData)

TRANSPOSE.

###
at line 690
```
static mixed
```**VLOOKUP**(mixed $lookup_value, mixed $lookup_array, mixed $index_number, mixed $not_exact_match = true)

**VLOOKUP**(mixed $lookup_value, mixed $lookup_array, mixed $index_number, mixed $not_exact_match = true)

VLOOKUP The VLOOKUP function searches for value in the left-most column of lookup_array and returns the value in the same row based on the index_number.

###
at line 765
```
static mixed
```**HLOOKUP**(mixed $lookup_value, mixed $lookup_array, mixed $index_number, mixed $not_exact_match = true)

**HLOOKUP**(mixed $lookup_value, mixed $lookup_array, mixed $index_number, mixed $not_exact_match = true)

HLOOKUP The HLOOKUP function searches for value in the top-most row of lookup_array and returns the value in the same column based on the index_number.

###
at line 836
```
static mixed
```**LOOKUP**(mixed $lookup_value, mixed $lookup_vector, null|mixed $result_vector = null)

**LOOKUP**(mixed $lookup_value, mixed $lookup_vector, null|mixed $result_vector = null)

LOOKUP The LOOKUP function searches for value either from a one-row or one-column range or from an array.