Microsoft Office Tutorials and References

In Depth Information

**Syntax**

Syntax

COLUMN(reference)

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.

Using

Using
HLOOKUP

HLOOKUP
for Horizontal Lookup Tables

for Horizontal Lookup Tables

HLOOKUP stands for horizontal lookup. This function is similar to

VLOOKUP.

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-

tion.

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.

Syntax

HLOOKUP(lookup_value,table_array,row_index_num,range_lookup)

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

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

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;