Written by Provides a range reference that is displaced by a specified number of rows and columns from a given starting cell reference.
Returns the position of an item in a specified range that corresponds to a given value.
Searches a row or column for a specific key and returns the corresponding value from a specified result range that aligns with the search input.
Returns a reference to a cell defined by a text string.
Retrieves the content of a cell based on its specified row and column indices.
Horizontal search. Looks through the initial row of a specified range for a key and retrieves the value from a designated cell in the corresponding column.
Retrieves an aggregated value from a pivot table based on designated row and column headings.
Provides the formula output as a string.
Calculates the number of columns in a chosen array or range.
Provides the column index for a given cell, mapping `A` to `1`.