Microsoft Office Tutorials and References
In Depth Information
The COLUMN function returns the column number of a given reference. This
function takes the argument reference, which is the cell or range of cells for
which you want the column number. If referenceis omitted, it is assumed to be
the reference of the cell in which the COLUMN function appears.
If referenceis a range of cells, and if COLUMN is entered as a horizontal
array, COLUMN returns the column numbers of referenceas a horizontal
array. In this case, referencecannot refer to multiple areas.
HLOOKUP for Horizontal Lookup Tables
for Horizontal Lookup Tables
HLOOKUP stands for horizontal lookup. This function is similar to
HLOOKUP operates in two distinct manners, based on the fourth parameter.
If the fourth parameter is the value FALSE, then HLOOKUP is looking for
an exact match in the top row of the table. This is fine when you are looking
up product codes, customer numbers, or any other discrete bits of informa-
However, if the fourth parameter is the value TRUE or is omitted, HLOOKUP
is treating the first row of the table as a sorted range of values. Excel
looks for the closest lower value than the one you specified. This is fine
when you are trying to determine in which range a value belongs.
The HLOOKUP function searches for a value in the top row of a table. When
the value is found, HLOOKUP returns a value from a particular row in the
column. This function takes the following arguments:
lookup_value — This is a value to be found in the first row of the
table. lookup_valuecan be a value, a reference, or a text string.
table_array — This is a table of information in which data is looked
up. You use a reference to a range or a range name. The values in the
first row of table_arraycan be text, numbers, or logical values. If
range_lookupis TRUE, the values in the first row of table_array
must be placed in ascending order, such as ..., – 2, – 1, 0, 1, 2,...; A – Z;