Owner manual

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).