Lookup and Reference

Class Library Overview > Supported Formula Functions

For further informations about argument types, restrictions and return values please see Office Open XML File Formats - ISO/IEC 29500 - 1, Chapter: 18.17.7 Predefined Function Definitions.

Formula Description
ADDRESS(row-number,col-number[,[ref-type][,[ A1-ref-style-flag][,sheet-name]]]) Creates a cell address, given the specified row and column numbers.
CHOOSE(index,argument-list) Selects the argument in argument-list that corresponds by position to index.
COLUMN([ reference ]) Finds the number of the column(s) corresponding to reference. If reference is omitted, the behavior is as if reference referred to the cell containing the formula.
COLUMNS(array) Finds the number of columns corresponding to array. (Limitations: Only supported for cell references and cell reference ranges.)
ROW([ reference ]) Finds the number of the row(s) corresponding to reference. If reference is omitted, the behavior is as if reference referred to the cell containing the formula.
ROWS(array) Finds the number of rows corresponding to array (Limitations: Only supported for cell references and cell reference ranges.)