Google Sheets reference

HLOOKUP in Google Sheets

Works in Google Sheets1 worked example

Worked examples (1)

These formulas work in Google Sheets with identical syntax.

Lookup & Referenceintermediate

=HLOOKUP(B1,$B$1:$F$5,3,FALSE)

Also in Excel

See the full HLOOKUP reference for Excel — including all worked examples, common errors, and FAQ.