Microsoft Office Tutorials and References

In Depth Information

**Syntax**

or FALSE, TRUE. Otherwise, HLOOKUP might not give the correct

value. If range_lookupis FALSE, table_arraydoes not need to be

sorted. The search is not case-sensitive: Both uppercase and lower-

case text are equivalent.

•
row_index_num

row_index_num
—
This is the row number in table_arrayfrom which

the matching value is returned. A row_index_numof 1 returns the first

row value in table_array, a row_index_numof 2 returns the second

row value in table_array, and so on. If row_index_numis less than 1,

HLOOKUP returns a #VALUE! error; if row_index_numis greater than

the number of rows in table_array, HLOOKUP returns a #REF! error.

•
range_lookup

range_lookup
—
This is a logical value that specifies whether you

want HLOOKUP to find an exact match or an approximate match. If it

is TRUE or omitted, an approximate match is returned. In other words, if

an exact match is not found, the next largest value that is less than

lookup_valueis returned. If it is FALSE, HLOOKUP finds an exact

match. If one is not found, the error #N/A is returned.

Even though you are probably familiar with sorting a list from top to bot-

tom, most people rarely sort a list from left to right. If you are using the

TRUE version of HLOOKUP, make sure that your table is sorted from left to

right by the top row. To sort data from left to right, follow these steps:

11. Select your range of data. In
Figure 12.26
,
this is G3:L8. Do not include

column F because it should not be sorted.