HLOOKUP Formula

The HLOOKUP Function lets you search for a value in the first row of a table (the “horizontal” row), and return a value from another row in the same column.

• Syntax: =HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup]) /lookup_value: What you’re searching for (for example, a product name). /table_array: The range of cells containing your data. /row_index_num: The row number (starting from the top of the table) to return a value from. /[range_lookup]: FALSE for an exact match, TRUE (or omitted) for an approximate match.
• Example: =HLOOKUP("Q2", A1:D3, 3, FALSE)
  This searches for "Q2" in the first row of the range A1:D3 and returns the value from the third row of the matching column.
  Use FALSE for an exact match.

---

• Task: Try the embedded Excel Online sheet below.
• Fill in the "Result" column using HLOOKUP to find each quarter’s result for the given year.