---
layout: doc
outline: deep
lang: en-US
---

# Lookup and Reference functions

At the moment IronCalc only supports a few function in this section.  
You can track the progress in this [GitHub issue](https://github.com/ironcalc/IronCalc/issues/52).

| Function     | Status                                         | Documentation |
| ------------ | ---------------------------------------------- | ------------- |
| ADDRESS      | <Badge type="info" text="Not implemented yet" /> | –             |
| AREAS        | <Badge type="info" text="Not implemented yet" /> | –             |
| CHOOSE       | <Badge type="tip" text="Available" />          | –             |
| CHOOSECOLS   | <Badge type="info" text="Not implemented yet" /> | –             |
| CHOOSEROWS   | <Badge type="info" text="Not implemented yet" /> | –             |
| COLUMN       | <Badge type="tip" text="Available" />          | –             |
| COLUMNS      | <Badge type="tip" text="Available" />          | –             |
| DROP         | <Badge type="info" text="Not implemented yet" /> | –             |
| EXPAND       | <Badge type="info" text="Not implemented yet" /> | –             |
| FILTER       | <Badge type="info" text="Not implemented yet" /> | –             |
| FORMULATEXT  | <Badge type="info" text="Not implemented yet" /> | –             |
| GETPIVOTDATA | <Badge type="info" text="Not implemented yet" /> | –             |
| HLOOKUP      | <Badge type="tip" text="Available" />          | –             |
| HSTACK       | <Badge type="info" text="Not implemented yet" /> | –             |
| HYPERLINK    | <Badge type="info" text="Not implemented yet" /> | –             |
| IMAGE        | <Badge type="info" text="Not implemented yet" /> | –             |
| INDEX        | <Badge type="tip" text="Available" />          | –             |
| INDIRECT     | <Badge type="tip" text="Available" />          | –             |
| LOOKUP       | <Badge type="tip" text="Available" />          | –             |
| MATCH        | <Badge type="tip" text="Available" />          | –             |
| OFFSET       | <Badge type="tip" text="Available" />          | –             |
| ROW          | <Badge type="tip" text="Available" />          | –             |
| ROWS         | <Badge type="info" text="Not implemented yet" /> | –             |
| RTD          | <Badge type="info" text="Not implemented yet" /> | –             |
| SORT         | <Badge type="info" text="Not implemented yet" /> | –             |
| SORTBY       | <Badge type="info" text="Not implemented yet" /> | –             |
| TAKE         | <Badge type="info" text="Not implemented yet" /> | –             |
| TOCOL        | <Badge type="info" text="Not implemented yet" /> | –             |
| TOROW        | <Badge type="info" text="Not implemented yet" /> | –             |
| TRANSPOSE    | <Badge type="info" text="Not implemented yet" /> | –             |
| UNIQUE       | <Badge type="info" text="Not implemented yet" /> | –             |
| VLOOKUP      | <Badge type="tip" text="Available" />          | –             |
| VSTACK       | <Badge type="info" text="Not implemented yet" /> | –             |
| WRAPCOLS     | <Badge type="info" text="Not implemented yet" /> | –             |
| WRAPROWS     | <Badge type="info" text="Not implemented yet" /> | –             |
| XLOOKUP      | <Badge type="tip" text="Available" />          | –             |
| XMATCH       | <Badge type="info" text="Not implemented yet" /> | –             |
