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.
| Function | Status | Documentation |
|---|---|---|
| ADDRESS | Not implemented yet | – |
| AREAS | Not implemented yet | – |
| CHOOSE | Available | – |
| CHOOSECOLS | Not implemented yet | – |
| CHOOSEROWS | Not implemented yet | – |
| COLUMN | Available | COLUMN |
| COLUMNS | Available | – |
| DROP | Not implemented yet | – |
| EXPAND | Not implemented yet | – |
| FILTER | Not implemented yet | – |
| FORMULATEXT | Not implemented yet | – |
| GETPIVOTDATA | Not implemented yet | – |
| HLOOKUP | Available | – |
| HSTACK | Not implemented yet | – |
| HYPERLINK | Not implemented yet | – |
| IMAGE | Not implemented yet | – |
| INDEX | Available | – |
| INDIRECT | Available | – |
| LOOKUP | Available | – |
| MATCH | Available | – |
| OFFSET | Available | – |
| ROW | Available | – |
| ROWS | Not implemented yet | – |
| RTD | Not implemented yet | – |
| SORT | Not implemented yet | – |
| SORTBY | Not implemented yet | – |
| TAKE | Not implemented yet | – |
| TOCOL | Not implemented yet | – |
| TOROW | Not implemented yet | – |
| TRANSPOSE | Not implemented yet | – |
| UNIQUE | Not implemented yet | – |
| VLOOKUP | Available | – |
| VSTACK | Not implemented yet | – |
| WRAPCOLS | Not implemented yet | – |
| WRAPROWS | Not implemented yet | – |
| XLOOKUP | Available | – |
| XMATCH | Not implemented yet | – |