Written by Returns values from the result range corresponding to the location of a found match in the lookup range. If a match isn’t located, it delivers the nearest match instead.
Vertical lookup. Searches the first column of a specified range for a key and retrieves the corresponding value from another cell in the same row.
Calculates the total number of rows within a given array or range.
Returns the number of the row containing a specified cell.
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.