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 | CHOOSE |
| CHOOSECOLS | Not implemented yet | – |
| CHOOSEROWS | Not implemented yet | – |
| COLUMN | Available | COLUMN |
| COLUMNS | Available | COLUMNS |
| DROP | Available | – |
| EXPAND | Not implemented yet | – |
| FILTER | Available | – |
| FORMULATEXT | Available | – |
| 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 | Available | – |
| RTD | Not implemented yet | – |
| SORT | Available | – |
| SORTBY | Available | – |
| TAKE | Available | – |
| TOCOL | Available | – |
| TOROW | Available | – |
| TRANSPOSE | Available | – |
| TRIMRANGE | Available | – |
| UNIQUE | Available | – |
| VLOOKUP | Available | – |
| VSTACK | Not implemented yet | – |
| WRAPCOLS | Not implemented yet | – |
| WRAPROWS | Not implemented yet | – |
| XLOOKUP | Available | – |
| XMATCH | Available | – |