Formulas and Functions

close match (TRUE, 1, or omitted): If there’s no exact match, select the column with
the largest top-row value that is less than the search value. Wildcards can’t be used
in search-for.
exact match (FALSE or 0): If there’s no exact match, return an error. Wildcards can
be used in search-for.
Usage Notes
HLOOKUP compares a search value to the values in the top row of a specied range. Â
Unless an exact match is required, the column containing the largest top-row value
that is less than the search value is selected. Then, the value from the specied row
in that column is returned by the function. If an exact match is required and none of
the top-row values match the search value, the function returns an error.
Examples
Given the following table:
=HLOOKUP(20, A1:E4, 2) returns “E.”
=HLOOKUP(39, A1:E4, 2) returns “E.”
=HLOOKUP(”M”, A2:E4, 2) returns “dolor.”
=HLOOKUP(”C”, A2:E3, 2) returns “lorem.”
=HLOOKUP(”blandit”, A3:E4, 2) returns “5.”
=HLOOKUP(”C”, A2:E4, 3, TRUE) returns “1.”
=HLOOKUP(”C”, A2:E4, 3, FALSE) returns an error because the value can’t be found (there is no exact
match).
Related Topics
For related functions and additional information, see:
“LOOKUP” on page 217
“MATCH” on page 218
“VLOOKUP” on page 223
“Specifying Conditions and Using Wildcards” on page 360
“Listing of Reference Functions” on page 206
“Value Types” on page 36
212 Chapter 9 Reference Functions