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.
Search JabSto ::




Custom Search