Skip to content
Excel

HLOOKUP function in Excel

Looks in the top row of an array and returns the value of the indicated cell

=HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])

HLOOKUP syntax and parameters

Four arguments, three required.

  • lookup_valueanyRequired
  • table_arrayarrayRequired
  • row_index_numnumberRequired
  • range_lookupanyOptional

HLOOKUP examples

Formulas you'll actually reuse.

  1. Q3 revenue from a table whose quarters run across the top row (row 3 = revenue):

    =HLOOKUP("Q3", A1:E5, 3, FALSE)

    Result48900

  2. Commission rate for a sale — approximate match against tier thresholds sorted ascending in row 1:

    =HLOOKUP(B2, $A$1:$G$2, 2, TRUE)

    Result0.05

HLOOKUP in Google Sheets

Same name — your formula ports as-is.

Try HLOOKUP in the playground

Edit the example — nothing to install.

Preloaded with the HLOOKUP formula from Example 1 — change anything and watch it respond.

Loading the editor…

HLOOKUP errors

What they mean — and the fixes.

  • #N/A

    No header matched — with FALSE the match is exact, so check spaces and case; use TRUE only when the top row is sorted ascending.

Related functions

More ways Excel gets this done.