# Lookup and Reference Functions

## Content

DsExcel.NET provides the following lookup and reference functions, listed alphabetically.

| Function | Description |
| -------- | ----------- |
| [ADDRESS](/document-solutions/dot-net-excel-api/docs/online/formula-reference/lookup-and-reference-functions/address) | This function uses the row and column numbers to create a cell address in text. |
| [AREAS](/document-solutions/dot-net-excel-api/docs/online/formula-reference/lookup-and-reference-functions/areas) | This function returns the number of areas in a reference. |
| [CHOOSE](/document-solutions/dot-net-excel-api/docs/online/formula-reference/lookup-and-reference-functions/choose) | This function returns a value from a list of values. |
| [CHOOSECOLS](/document-solutions/dot-net-excel-api/docs/online/formula-reference/lookup-and-reference-functions/choosecols) | This function returns the specified columns from an array. |
| [CHOOSEROWS](/document-solutions/dot-net-excel-api/docs/online/formula-reference/lookup-and-reference-functions/chooserows) | This function returns the specified rows from an array. |
| [COLUMN](/document-solutions/dot-net-excel-api/docs/online/formula-reference/lookup-and-reference-functions/column) | This function returns the column number of a reference. |
| [COLUMNS](/document-solutions/dot-net-excel-api/docs/online/formula-reference/lookup-and-reference-functions/columns) | This function returns the number of columns in an array. |
| [DROP](/document-solutions/dot-net-excel-api/docs/online/formula-reference/lookup-and-reference-functions/drop) | This function excludes a specified number of rows or columns from the start or end of an array. |
| [EXPAND](/document-solutions/dot-net-excel-api/docs/online/formula-reference/lookup-and-reference-functions/expand) | This function expands or pads an array to the specified row and column dimensions. |
| [FILTER](/document-solutions/dot-net-excel-api/docs/online/formula-reference/lookup-and-reference-functions/filter) | This function filters a range or array. |
| [FORMULATEXT](/document-solutions/dot-net-excel-api/docs/online/formula-reference/lookup-and-reference-functions/formulatext) | This function extracts data stored in a PivotTable. |
| [GETPIVOTDATA](/document-solutions/dot-net-excel-api/docs/online/formula-reference/lookup-and-reference-functions/getpivotdata) | This function searches for a value in the top row and then returns a value in the same column from a specified row. |
| [GROUPBY](/document-solutions/dot-net-excel-api/docs/online/formula-reference/lookup-and-reference-functions/groupby) | This function creates a summary of your data using formula and supports grouping along row fields and aggregating the associated values. |
| [HLOOKUP](/document-solutions/dot-net-excel-api/docs/online/formula-reference/lookup-and-reference-functions/hlookup) | This function creates a shortcut or jump that opens a document stored on a network server, an intranet, or the Internet. |
| [HSTACK](/document-solutions/dot-net-excel-api/docs/online/formula-reference/lookup-and-reference-functions/hstack) | This function stack arrays horizontally. |
| [HYPERLINK](/document-solutions/dot-net-excel-api/docs/online/formula-reference/lookup-and-reference-functions/hyperlink) | This function creates a shortcut that opens documents stored on the Internet. |
| [IMAGE](/document-solutions/dot-net-excel-api/docs/online/formula-reference/lookup-and-reference-functions/image) | This function input an URL or a base64 string to show an image in cell. |
| [INDEX](/document-solutions/dot-net-excel-api/docs/online/formula-reference/lookup-and-reference-functions/index) | This function returns a value or the reference to a value from within an array or range. |
| [INDIRECT](/document-solutions/dot-net-excel-api/docs/online/formula-reference/lookup-and-reference-functions/indirect) | This function returns the reference specified by a text string. References are immediately evaluated to display their contents. |
| [LOOKUP](/document-solutions/dot-net-excel-api/docs/online/formula-reference/lookup-and-reference-functions/lookup) | This function searches for a value and returns a value from the same location in a second area. |
| [MATCH](/document-solutions/dot-net-excel-api/docs/online/formula-reference/lookup-and-reference-functions/match) | This function returns the relative position of a specified item in a range. |
| [OFFSET](/document-solutions/dot-net-excel-api/docs/online/formula-reference/lookup-and-reference-functions/offset) | This function returns a reference to a range. The range is a specified number of rows and columns from a cell or range of cells. The function returns a single cell or a range of cells. |
| [PIVOTBY](/document-solutions/dot-net-excel-api/docs/online/formula-reference/lookup-and-reference-functions/pivotby) | This function returns the group, aggregate, sort, and filter data based on the row and column fields that you specify. |
| [ROW](/document-solutions/dot-net-excel-api/docs/online/formula-reference/lookup-and-reference-functions/row) | This function returns the number of a row from a reference. |
| [ROWS](/document-solutions/dot-net-excel-api/docs/online/formula-reference/lookup-and-reference-functions/rows) | This function returns the number of rows in an array. |
| [SINGLE](/document-solutions/dot-net-excel-api/docs/online/formula-reference/lookup-and-reference-functions/single) | This function returns a single value when given a value, range, or array. |
| [SORT](/document-solutions/dot-net-excel-api/docs/online/formula-reference/lookup-and-reference-functions/sort) | This function sorts a range or array. |
| [SORTBY](/document-solutions/dot-net-excel-api/docs/online/formula-reference/lookup-and-reference-functions/sortby) | This function sorts a range or array based on the values in a corresponding range or array. |
| [TAKE](/document-solutions/dot-net-excel-api/docs/online/formula-reference/lookup-and-reference-functions/take) | This function returns a specified number of contiguous rows or columns from the start or end of an array. |
| [TOCOL](/document-solutions/dot-net-excel-api/docs/online/formula-reference/lookup-and-reference-functions/tocol) | This function returns the array in a single column. |
| [TOROW](/document-solutions/dot-net-excel-api/docs/online/formula-reference/lookup-and-reference-functions/torow) | The function returns the array in a single row. |
| [TRANSPOSE](/document-solutions/dot-net-excel-api/docs/online/formula-reference/lookup-and-reference-functions/transpose) | This function returns a vertical range of cells as a horizontal range or a horizontal range of cells as a vertical range. |
| [TRIMRANGE](/document-solutions/dot-net-excel-api/docs/online/formula-reference/lookup-and-reference-functions/trimrange) | This function excludes all empty rows and/or columns from the outer edges of a range or array.​​​​​​​​​​​​​​ |
| [UNIQUE](/document-solutions/dot-net-excel-api/docs/online/formula-reference/lookup-and-reference-functions/unique) | This function returns the unique values from a range or array. |
| [VLOOKUP](/document-solutions/dot-net-excel-api/docs/online/formula-reference/lookup-and-reference-functions/vlookup) | This function searches for a value in the leftmost column and returns a value in the same row from a column you specify. |
| [VSTACK](/document-solutions/dot-net-excel-api/docs/online/formula-reference/lookup-and-reference-functions/vstack) | This function appends arrays vertically and in sequence to return a larger array. |
| [WRAPCOLS](/document-solutions/dot-net-excel-api/docs/online/formula-reference/lookup-and-reference-functions/wrapcols) | This function wraps the provided row or column of values by columns after a specified number of elements to form a new array. |
| [WRAPROWS](/document-solutions/dot-net-excel-api/docs/online/formula-reference/lookup-and-reference-functions/wraprows) | This function wraps the provided row or column of values by rows after a specified number of elements to form a new array. |
| [XLOOKUP](/document-solutions/dot-net-excel-api/docs/online/formula-reference/lookup-and-reference-functions/xlookup) | This function searches a range or an array for a match and returns the corresponding item from a second range or array. By default, an exact match is used. |
| [XMATCH](/document-solutions/dot-net-excel-api/docs/online/formula-reference/lookup-and-reference-functions/xmatch) | This function returns the relative position of an item in an array. By default, an exact match is required. |