Excel functions in plain English

Looks up a value in the first column of a table.

Looks up a value in the first row of a table.

Returns a value at a position in a range.

Returns the position of a value in a range.

Chooses a value from a list by index.

Returns selected columns from an array.

Returns selected rows from an array.

Returns a specified number of rows or columns.

Removes rows or columns from an array result.

Combines arrays horizontally.

Combines arrays vertically.

Converts an array into one column.

Converts an array into one row.

Switches rows and columns.

Formats a value as text.

Joins text using a delimiter.

Combines text values.

Returns characters from the start of text.

Returns characters from the end of text.

Extracts text from a specified position.