Spread.NET 17 Formula Reference
Formula Functions / Functions H to L / HLOOKUP
In This Topic
    HLOOKUP
    In This Topic

    This function searches for a value in the top row and then returns a value in the same column from a specified row.

    Syntax

    HLOOKUP(value,array,row,approx)

    Arguments

    This function has these arguments:

    Argument Description
    value Value to be found in the first row
    array Array or range that contains the data to search
    row Row number in the array from which the matching value will be returned
    approx [Optional] Logical value indicating whether to find an approximate match; if omitted, uses TRUE and finds an approximate match

    Remarks

    If approx is FALSE, it finds an exact match, not an approximate match. If it cannot find one, it returns an #N/A error value.

    If approx is TRUE or omitted, and the value cannot be found, then the largest value that is less than the value is used.

    This function is similar to VLOOKUP except that it searches by row (horizontally), instead of vertically (by column).

    Data Types

    Accepts numeric or string data. Returns numeric data.

    Examples

    HLOOKUP("Test",A1:D5,3,TRUE)

    Version Available

    This function is available in product version 2.0 or later.

    See Also

    VLOOKUP | LOOKUP | Lookup Functions