How to Use HLOOKUP in Google Sheets

By Tomosuke Hasegawa · Updated Oct 29, 2026 · Beginner · 6 min read · includes 2 free exercises

In short: HLOOKUP searches the first row of a range for a value and returns a value from a row you choose in the same column. The formula is =HLOOKUP(search_key, range, index, [is_sorted]). Use FALSE for an exact match.

What HLOOKUP does

HLOOKUP is VLOOKUP turned on its side. When your headers run across the top (months in a row, for example), HLOOKUP looks for a header in the first row and returns a value from the column where it finds it.

HLOOKUP syntax

=HLOOKUP(search_key, range, index, [is_sorted])

A step-by-step example

Here are monthly figures in cells A1:D3, with the months across row 1.

ABCD
1MonthJanFebMar
2Sales12015090
3Costs8010070

To find the sales for February:

=HLOOKUP("Feb", A1:D3, 2, FALSE)

This returns 150. Here is why:

  1. Sheets scans the first row of A1:D3 and finds Feb in column C.
  2. The index is 2, so it returns the value from the second row of that column: 150.

Row 1 of the range is index 1, Sales is index 2 and Costs is index 3.

Always set is_sorted to FALSE for exact lookups

Because the default is TRUE, leaving the last argument out makes HLOOKUP assume a sorted row and return the nearest smaller match. For text headers like months that gives wrong answers with no warning. Google's help page also notes that wildcards and regular expressions are not supported, and that with FALSE and repeated keys, the first match is used.

Common HLOOKUP errors

Try it yourself

Use the monthly table above (A1:D3). Type your formula into the box, starting with =, then press Check.

Exercise 1: Sales for February

Write a formula that returns the Sales figure for Feb from A1:D3, using an exact match.

Hint: Sales is the second row of the range.

Exercise 2: Costs for March

Write a formula that returns the Costs figure for Mar from A1:D3, using an exact match.

Hint: Costs is the third row of the range.

What to learn next

Syntax and rules in this guide were checked against Google's HLOOKUP help page. See all guides.