Microsoft Office Tutorials and References
In Depth Information
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 — 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 — 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:
column F because it should not be sorted.