fx =HLOOKUP("Q1",A1:D2,2,FALSE)ABCSKU-4821Widget A$24.99SKU-7293Gadget B$89.50SKU-1056Tool C$12.75
🔍 Lookup

HLOOKUP Formula for Lookup

Horizontal lookup - search across a row. Copy-paste ready for Excel, Google Sheets, and Airtable.

=HLOOKUP("Q1",A1:D2,2,FALSE)
When you need this: When you have a quarterly results table with headers "Q1", "Q2", "Q3", "Q4" across row 1, and you need to find Q3 revenue.

How it works

  1. 1Search for the lookup value ("Q1") in the first row of the range (A1:D2).
  2. 2Once found, return the value from the specified row (2 = row 2, the revenue row).
  3. 3Similar to VLOOKUP, but searches horizontally instead of vertically.

Variations

HLOOKUP with range name
=HLOOKUP("Q2",QuarterlyTable,2,FALSE)
HLOOKUP with error handling
=IFERROR(HLOOKUP("Q3",A1:D2,2,FALSE),"Not Found")

Related Formulas

VLOOKUP — Look up a value in a table by matching the first columnLookupINDEX/MATCH — Flexible lookup - more powerful than VLOOKUPLookupXLOOKUP — Modern replacement for VLOOKUP (Excel 365)LookupFILTER — Return rows matching criteria (dynamic filter)Lookup

Need a formula that's not here?

Generate custom formula →