Below is the list of 16 useful Excel functions, please see below for details or check all the Excel functions here:
| Function | Formula |
|---|---|
| ADDRESS Function | Address(Row_Num, Column_Num, [Abs_Num], [A1], [Sheet_Text]) |
| AREAS Function | Areas(Array) |
| CHOOSE Function | Choose(Index_Num, Value1, [Value2], …) |
| COLUMN Function | Column([Reference]) |
| COLUMNS Function | Columns(Array) |
| HLOOKUP Function | Hlookup(Value, Array, Row_Num, [Range]) |
| HYPERLINK Function | Hyperlink(Link_Location, [Friendly_Name]) |
| INDEX Function | Index(Array, Row_Num, [Column_Num]) |
| INDIRECT Function | Indirect(Ref_Text, [A1]) |
| LOOKUP Function | Lookup(Lookup_Value, Lookup_Vector, [Result_Vector]) |
| MATCH Function | Match(Lookup_Value, Lookup_Array, [Match_Type]) |
| OFFSET Function | Offset(Reference, Rows, Cols, [Height], [Width]) |
| ROW Function | Row([Reference]) |
| ROWS Function | Rows(Array) |
| TRANSPOSE Function | Transpose(Array) |
| VLOOKUP function | Vlookup(Value, Range, Column Num, Match Logic) |