The basic LOOKUP function in Excel comes in two forms: vector lookup and array lookup. The vector form searches for a value in a single row or column and returns a corresponding value from another ...

Populating a dropdown with a dynamic list is easy thanks to Microsoft Excel’s UNIQUE() dynamic array function.

To extract and sort non-adjacent arrays in your data, nest the CHOOSECOLS or CHOOSEROWS functions inside your SORT or SORTBY ...

Microsoft is making some improvements to how formulas work in Excel, with a new feature called Dynamic Arrays that allows formulas to output values to more than one cell at a time.

Microsoft is opening up Excel to developers with a new JavaScript API. It will let developers use custom data types like images, cards, and arrays.