HLOOKUP

Returns the corresponding value from the specified row of table which matches exactly or approximately to the first row of the table.

Syntax

HLOOKUP(lookup_value, table_array, row_index, [range_lookup])

Arguments

Argument	Description	Required
lookup_value	The value to search for in the first row of table_array.	Required
table_array	The array from which to retrieve a value.	Required
row_index	The row number from which to retrieve a value.	Required
range_lookup	Whether to perform exact match (false) or approximate match (true). Defaults to true.	Optional

Examples

Find product price by name

Lookup with approximate match

Find category by score

Related Functions

Other Data functions:

• CHOOSE - Uses index to return a value from the list of value arguments
• COLUMN - Returns the column number of the current cell context.
• DROP - Drops the first N rows and optionally first N columns from an array. Returns an error if the result would be empty.
• FILTER - Returns a filtered array containing only rows that match the criteria
• GROUPBY - Groups data by a key and applies an aggregator function to each group
• HSTACK - Horizontally stacks arrays by appending columns
• INDEX - Returns a cell value from a list or table based on its column and row numbers.
• LAST - Returns the last N rows and optionally last N columns from an array. Returns an error if the result would be empty.
• MAP - Processes each row in an array with a formula including a COL or CELL keyword and returns it as a 2D array.
• MATCH - Returns the position of the item/lookup_value in the lookup_array or range.
• PICK - Selects specific columns from an array using column numbers or header names
• ROW - Returns the 1-indexed row number of the current cell
• SEQUENCE - Returns the list of generated sequential numbers in an array.
• SORT - Sorts the values in a range or array.
• TAKE - Returns the first N rows and optionally first N columns from an array. Returns an error if the result would be empty.
• TRANSPOSE - Returns the result after transposing the rows and columns of an array or range.
• UNIQUE - Returns a list of unique values in a list or range.
• VLOOKUP - Returns a value from a table by looking up a value in the first column and returning a value from the specified column
• VSTACK - Vertically stacks arrays by appending rows

---

← Back to Formula Reference