HLOOKUP Formula

This article explains how to use HLOOKUP formulas

Sample Usage

HLOOKUP(QA, DA, 1, 1)
HLOOKUP(135, DB, 2, 2)

Syntax

HLOOKUP (value, datasheet, row_index, [range_lookup])
  • value - The value to look for in the first column of a datasheet.
  • datasheet - The table from which to retrieve a value.
  • row_index - The row in the datasheet from which to retrieve a value.
  • range_lookup - [optional] 2 = approximate match (default). 1 = exact match.

Notes

  • Instead of a table range in a spreadsheet program (e.g. A1:B22), the value of the datasheet needs to be just the reference to that datasheet (eg. DA).