HLOOKUP The HLOOKUP function searches for value in the top-most row of lookup_array and returns the value in the same column based on the index_number.
LOOKUP The LOOKUP function searches for value either from a one-row or one-column range or from an array.
VLOOKUP The VLOOKUP function searches for value in the left-most column of lookup_array and returns the value in the same row based on the index_number.
Creates a cell address as text, given specified row and column numbers.
Uses lookup_value to return a value from the list of value arguments. Use CHOOSE to select one of up to 254 values based on the lookup_value.
Returns the column number of the given cell reference If the cell reference is a range of cells, COLUMN returns the column numbers of each column in the reference as a horizontal array. If cell reference is omitted, and the function is being called through the calculation engine, then it is assumed to be the reference of the cell in which the COLUMN function appears; otherwise this function returns 0.
Returns the number of columns in an array or reference.
The row number in table_array from which the matching value must be returned. The first row is 1.
Determines if you are looking for an exact match based on lookup_value.
The row in array from which to return a value. If row_num is omitted, column_num is required.
The column in array from which to return a value. If column_num is omitted, row_num is required.
Returns the reference specified by a text string. References are immediately evaluated to display their contents.
The number -1, 0, or 1. -1 means above, 0 means exact match, 1 means below. If match_type is 1 or -1, the list has to be ordered.
The reference from which you want to base the offset. Reference must refer to a cell or range of adjacent cells; otherwise, OFFSET returns the #VALUE! error value.
The number of rows, up or down, that you want the upper-left cell to refer to. Using 5 as the rows argument specifies that the upper-left cell in the reference is five rows below reference. Rows can be positive (which means below the starting reference) or negative (which means above the starting reference).
The number of columns, to the left or right, that you want the upper-left cell of the result to refer to. Using 5 as the cols argument specifies that the upper-left cell in the reference is five columns to the right of reference. Cols can be positive (which means to the right of the starting reference) or negative (which means to the left of the starting reference).
The height, in number of rows, that you want the returned reference to be. Height must be a positive number.
The width, in number of columns, that you want the returned reference to be. Width must be a positive number.
Returns the row number of the given cell reference If the cell reference is a range of cells, ROW returns the row numbers of each row in the reference as a vertical array. If cell reference is omitted, and the function is being called through the calculation engine, then it is assumed to be the reference of the cell in which the ROW function appears; otherwise this function returns 0.
Returns the number of rows in an array or reference.
arrayUnlike the Excel TRANSPOSE function, which will only work on a single row or column, this function will transpose a full matrix.
The column number in table_array from which the matching value must be returned. The first column is 1.